{"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-time-ceiling-floor\" title=\"Excel\u3067\u6642\u9593\u309215\u5206\u30fb30\u5206\u5358\u4f4d\u3067\u4e38\u3081\u308b\u65b9\u6cd5\uff5c\u5207\u308a\u4e0a\u3052\u30fb\u5207\u308a\u6368\u3066\uff08CEILING/FLOOR\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>","author_name":"doodle-on-web","categories":["Excel","CEILING\u95a2\u6570","FLOOR\u95a2\u6570","\u6642\u9593\u8a08\u7b97","\u696d\u52d9\u52b9\u7387\u5316"],"version":"1.0","provider_url":"https://hatena.blog","title":"Excel\u3067\u6642\u9593\u309215\u5206\u30fb30\u5206\u5358\u4f4d\u3067\u4e38\u3081\u308b\u65b9\u6cd5\uff5c\u5207\u308a\u4e0a\u3052\u30fb\u5207\u308a\u6368\u3066\uff08CEILING/FLOOR\uff09","url":"https://www.doodle-office.work/entry/excel-time-ceiling-floor","type":"rich","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/d/doodle-on-web/20260626/20260626080224.png","description":"\u52e4\u6020\u8868\u3084\u8acb\u6c42\u66f8\u3067\u300c\u6253\u523b\u6642\u9593\u309215\u5206\u5358\u4f4d\u306b\u4e38\u3081\u305f\u3044\u300d\u300c30\u5206\u672a\u6e80\u306f\u5207\u308a\u6368\u3066\u305f\u3044\u300d\u3068\u3044\u3046\u5834\u9762\u306f\u591a\u3044\u3082\u306e\u3067\u3059\u3002\u7d50\u8ad6\u304b\u3089\u8a00\u3046\u3068\u300115\u5206\u5358\u4f4d\u3067\u5207\u308a\u4e0a\u3052\u308b\u306a\u3089 =CEILING(A1,\"0:15\")\u3001\u5207\u308a\u6368\u3066\u308b\u306a\u3089 =FLOOR(A1,\"0:15\") \u3067OK\u3067\u3059\u3002\u4ee5\u4e0b\u3067\u4ed5\u7d44\u307f\u3068\u5b9f\u52d9\u3067\u306e\u4f7f\u3044\u65b9\u3001\u3064\u307e\u305a\u304d\u3084\u3059\u3044\u30dd\u30a4\u30f3\u30c8\u307e\u3067\u307e\u3068\u3081\u3066\u89e3\u8aac\u3057\u307e\u3059\u3002 \u307e\u305a\u77e5\u3063\u3066\u304a\u304d\u305f\u3044\uff1aExcel\u306e\u300c\u6642\u9593\u300d\u306e\u6b63\u4f53 \u6642\u9593\u3092\u5207\u308a\u4e0a\u3052\u308b\uff1aCEILING\u95a2\u6570 \u6642\u9593\u3092\u5207\u308a\u6368\u3066\u308b\uff1aFLOOR\u95a2\u6570 \u5b9f\u52d9\u3067\u306e\u4f7f\u3044\u65b9\uff1a\u52e4\u52d9\u6642\u9593\u309215\u5206\u5358\u4f4d\u3067\u96c6\u8a08\u3059\u308b \u5358\u4f4d\u306e\u6307\u5b9a\u306f\u3053\u306e3\u30d1\u30bf\u30fc\u30f3\u3092\u899a\u3048\u308c\u3070OK \u3064\u307e\u305a\u304d\u3084\u3059\u3044\u30dd\u30a4\u30f3\u30c8 \u300c\u56db\u6368\u4e94\u5165\u300d\u3057\u305f\u3044\u3068\u304d\u306f MROUN\u2026","provider_name":"Hatena Blog","height":"190","width":"100%","published":"2026-06-26 08:02:51","blog_title":"doodle-on-web","blog_url":"https://www.doodle-office.work/"}