{"title":"Excel\u3067\u6642\u523b\u306b\u5c0f\u6570\u306e\u5206\u3092\u8db3\u3059\uff5c1440\u3067\u5272\u308b\u306e\u304c\u6b63\u89e3\uff08TIME\u95a2\u6570\u306fNG\uff09","provider_url":"https://hatena.blog","blog_title":"doodle-on-web","description":"Excel\u3067\u6642\u523b\u306b\u300c12.5\u5206\u300d\u306e\u3088\u3046\u306a\u5c0f\u6570\u306e\u5206\u3092\u8db3\u3059\u306a\u3089\u3001\u6b63\u89e3\u306f =MOD(A2+B2/1440,1) \u3067\u3059\u3002TIME\u95a2\u6570\u306f\u5f15\u6570\u306e\u5c0f\u6570\u3092\u5207\u308a\u6368\u3066\u308b\u305f\u3081\u300112.5\u5206\u304c12\u5206\u306b\u306a\u3063\u306630\u79d2\u304c\u6d88\u3048\u307e\u3059\u300224\u6642\u9593\u3092\u8d85\u3048\u308b\u5408\u8a08\u3060\u3051\u306f[h]:mm\u66f8\u5f0f\u3067\u8868\u793a\u3057\u307e\u3059\u3002 \u4f5c\u696d\u6642\u9593\u306e\u8a18\u9332\u3084\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7\u88dc\u6b63\u3067\u306f\u300c12.5\u5206\u5f8c\u300d\u300c7.25\u5206\u524d\u300d\u3068\u3044\u3063\u305f\u5024\u3092\u6271\u3046\u5834\u9762\u304c\u3088\u304f\u3042\u308a\u307e\u3059\u3002\u3068\u3053\u308d\u304cTIME\u95a2\u6570\u3067\u7d20\u76f4\u306b\u66f8\u304f\u3068\u3001\u30a8\u30e9\u30fc\u3082\u51fa\u306a\u3044\u307e\u307e\u79d2\u3060\u3051\u304c\u9759\u304b\u306b\u843d\u3061\u308b\u3002\u539f\u56e0\u3082\u5bfe\u51e6\u3082\u5358\u7d14\u306a\u306e\u3067\u3001\u3053\u3053\u3067\u4e00\u5ea6\u6574\u7406\u3057\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002 \u25b2 \u6642\u523b\u306f\u300c1\u65e5\uff1d1\u300d\u306e\u6570\u5024\u3002\u3053\u306e\u524d\u63d0\u3055\u3048\u62bc\u3055\u3048\u308c\u3070\u8a08\u7b97\u5f0f\u306f\u4e00\u672c\u5316\u3067\u304d\u308b TIME\u95a2\u6570\u3067\u5c0f\u6570\u306e\u5206\u304c\u6d88\u3048\u308b\u2026","author_name":"doodle-on-web","provider_name":"Hatena Blog","blog_url":"https://www.doodle-office.work/","categories":["Excel","\u95a2\u6570","\u6642\u9593\u8a08\u7b97","\u30a8\u30e9\u30fc\u5bfe\u51e6","\u696d\u52d9\u52b9\u7387\u5316"],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fwww.doodle-office.work%2Fentry%2Fexcel-add-decimal-minutes-1440\" title=\"Excel\u3067\u6642\u523b\u306b\u5c0f\u6570\u306e\u5206\u3092\u8db3\u3059\uff5c1440\u3067\u5272\u308b\u306e\u304c\u6b63\u89e3\uff08TIME\u95a2\u6570\u306fNG\uff09 - 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>","height":"190","width":"100%","author_url":"https://blog.hatena.ne.jp/doodle-on-web/","version":"1.0","url":"https://www.doodle-office.work/entry/excel-add-decimal-minutes-1440","type":"rich","published":"2026-09-02 08:07:18","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/d/doodle-on-web/20260902/20260902080655.png"}