{"title":"\u3010Excel\u3011\u6642\u523b\u306b\u300c1.5\u6642\u9593\u300d\u3092\u8db3\u3059\uff1dMOD(A2+B2/24,1)\uff5c30\u5206\u304c\u6d88\u3048\u308bTIME\u95a2\u6570\u306e\u7f60","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/d/doodle-on-web/20260829/20260829080402.png","url":"https://www.doodle-office.work/entry/excel-add-decimal-hours-to-time","blog_url":"https://www.doodle-office.work/","author_name":"doodle-on-web","author_url":"https://blog.hatena.ne.jp/doodle-on-web/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.doodle-office.work%2Fentry%2Fexcel-add-decimal-hours-to-time\" title=\"\u3010Excel\u3011\u6642\u523b\u306b\u300c1.5\u6642\u9593\u300d\u3092\u8db3\u3059\uff1dMOD(A2+B2/24,1)\uff5c30\u5206\u304c\u6d88\u3048\u308bTIME\u95a2\u6570\u306e\u7f60 - 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>","categories":["Excel","\u95a2\u6570","\u6642\u9593\u8a08\u7b97","\u65e5\u4ed8\u51e6\u7406","\u696d\u52d9\u52b9\u7387\u5316"],"description":"Excel\u3067\u6642\u523b\u306b\u5c0f\u6570\u306e\u6642\u9593\uff081.5\u6642\u9593\u30010.25\u6642\u9593\u306a\u3069\uff09\u3092\u8db3\u3059\u6700\u77ed\u306e\u6570\u5f0f\u306f =MOD(A2+B2/24,1) \u3067\u3059\u3002\u5c0f\u6570\u6642\u9593\u309224\u3067\u5272\u3063\u3066\u30b7\u30ea\u30a2\u30eb\u5024\u306b\u5909\u63db\u3057\u3001MOD\u306724\u6642\u8d85\u3048\u3092\u7fcc\u65e5\u6271\u3044\u306b\u4e38\u3081\u307e\u3059\u3002\u8868\u793a\u5f62\u5f0f\u306f h:mm \u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002 TIME\u95a2\u6570\u3092\u4f7f\u3046\u624b\u3082\u3042\u308a\u307e\u3059\u304c\u3001TIME(B2,0,0) \u3068\u66f8\u304f\u306830\u5206\u304c\u97f3\u3082\u306a\u304f\u6d88\u3048\u307e\u3059\u3002\u52e4\u6020\u8868\u3084\u4f5c\u696d\u4e88\u5b9a\u8868\u3067\u5fc5\u305a\u3064\u307e\u305a\u304f\u30dd\u30a4\u30f3\u30c8\u3092\u3001\u75c7\u72b6\u5225\u306e\u9006\u5f15\u304d\u8868\u307e\u3067\u542b\u3081\u3066\u9806\u306b\u6f70\u3057\u3066\u3044\u304d\u307e\u3059\u3002 \u25b2 Date and Time \u30b5\u30f3\u30d7\u30eb \u76ee\u6b21 Excel\u306e\u6642\u523b\u306f\u300c1\u65e5\uff1d1\u300d\u306e\u30b7\u30ea\u30a2\u30eb\u5024 \u65b9\u6cd51\uff1a\u5c0f\u6570\u306e\u6642\u9593\u309224\u3067\u5272\u3063\u3066\u8db3\u3059\uff08\u63a8\u5968\uff09 \u65b9\u6cd52\uff1aTIME\u95a2\u6570\u3067\u5c0f\u6570\u306e\u6642\u9593\u3092\u2026","version":"1.0","provider_url":"https://hatena.blog","blog_title":"doodle-on-web","height":"190","provider_name":"Hatena Blog","width":"100%","published":"2026-08-29 08:04:27","type":"rich"}