{"provider_name":"Hatena Blog","provider_url":"https://hatena.blog","author_name":"doodle-on-web","author_url":"https://blog.hatena.ne.jp/doodle-on-web/","title":"Excel\u3067\u52e4\u52d9\u6642\u9593\u3092\u8a08\u7b97\u3059\u308b\u65b9\u6cd5\uff5c\u65e5\u307e\u305f\u304e\u306e\u300c#####\u300d\u306fMOD\u3067\u4e00\u767a\u89e3\u6c7a","description":"Excel\u3067\u52e4\u52d9\u6642\u9593\u3092\u51fa\u3059\u306b\u306f =\u7d42\u4e86\u6642\u523b-\u958b\u59cb\u6642\u523b \u3068\u5165\u529b\u3057\u3001\u8868\u793a\u5f62\u5f0f\u3092 [h]:mm \u306b\u3059\u308b\u3060\u3051\u3067\u3059\u3002\u591c\u52e4\u306a\u3069\u65e5\u3092\u307e\u305f\u3044\u3067 ##### \u306b\u306a\u308b\u5834\u5408\u306f =MOD(\u7d42\u4e86-\u958b\u59cb,1) \u306b\u5909\u3048\u308c\u3070\u4e00\u767a\u3067\u89e3\u6c7a\u3057\u307e\u3059\u3002\u4f11\u61a9\u3092\u5f15\u304f\u306a\u3089\u5f15\u304d\u7b97\u3001\u6642\u7d66\u3092\u639b\u3051\u308b\u306a\u3089 \u00d724 \u3067\u3059\u3002 \u3068\u306f\u3044\u3048\u5b9f\u52d9\u3067\u306f\u300c\u4f11\u61a9\u3092\u5f15\u304d\u305f\u3044\u300d\u300c15\u5206\u5358\u4f4d\u306b\u4e38\u3081\u305f\u3044\u300d\u3068\u8981\u4ef6\u304c\u5897\u3048\u3001\u5358\u7d14\u306a\u5f15\u304d\u7b97\u3067\u306f\u8db3\u308a\u306a\u304f\u306a\u308a\u307e\u3059\u3002\u3053\u306e\u8a18\u4e8b\u3067\u306f\u52e4\u6020\u8868\u306e\u6642\u523b\u8a08\u7b97\u3092\u3001\u57fa\u672c\u304b\u3089\u65e5\u307e\u305f\u304e\u30fb\u4e38\u3081\u30fb\u5408\u8a08\u30fb\u30b3\u30d4\u30da\u7528\u306e\u5b8c\u6210\u5f62\u307e\u3067\u9806\u306b\u6574\u7406\u3057\u307e\u3059\u3002 \u25b2 Date and Time \u30b5\u30f3\u30d7\u30eb \u3053\u306e\u8a18\u4e8b\u306e\u5217\u306e\u6c7a\u3081\u3054\u3068 \u6570\u5f0f\u3092\u305d\u306e\u307e\u307e\u30b3\u30d4\u30fc\u3067\u304d\u308b\u3088\u3046\u3001\u4ee5\u4e0b\u3067\u7d71\u4e00\u3057\u307e\u3059\u3002 \u5217 \u5185\u5bb9 \u2026","height":"190","blog_url":"https://www.doodle-office.work/","published":"2026-09-17 08:08:56","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/d/doodle-on-web/20260917/20260917080825.png","type":"rich","version":"1.0","categories":["Excel","\u95a2\u6570","\u6642\u9593\u8a08\u7b97","\u696d\u52d9\u52b9\u7387\u5316"],"blog_title":"doodle-on-web","width":"100%","url":"https://www.doodle-office.work/entry/excel-working-hours-calculation","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.doodle-office.work%2Fentry%2Fexcel-working-hours-calculation\" title=\"Excel\u3067\u52e4\u52d9\u6642\u9593\u3092\u8a08\u7b97\u3059\u308b\u65b9\u6cd5\uff5c\u65e5\u307e\u305f\u304e\u306e\u300c#####\u300d\u306fMOD\u3067\u4e00\u767a\u89e3\u6c7a - doodle-on-web\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>"}