{"image_url":null,"blog_url":"https://hrroct.hatenablog.com/","categories":["Windows 11","Excel"],"url":"https://hrroct.hatenablog.com/entry/2025/06/08/121200","version":"1.0","type":"rich","width":"100%","height":"190","published":"2025-06-08 12:12:00","title":"\u52e4\u6020\u95a2\u9023\u306eExcel\u95a2\u6570\u96c6","author_url":"https://blog.hatena.ne.jp/hrroct/","blog_title":"HRR Co., Ltd.","description":"\u306f\u3058\u3081\u306b \u63b2\u984c\u901a\u308a\u3067\u3001\u5c0f\u30cd\u30bf\u3067\u3059\u3002 \u4f8b\u3048\u3070\u6b63\u793e\u54e1\u4ee5\u5916\u306e\u52e4\u6020\u3092### \u306f\u3058\u3081\u306b \u63b2\u984c\u901a\u308a\u3067\u3001\u5c0f\u30cd\u30bf\u3067\u3059\u3002 \u30b7\u30b9\u30c6\u30e0\u3092\u4f7f\u308f\u306a\u3044\u5834\u5408\u306e\u52e4\u6020\u7ba1\u7406\u306bExcel\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u3046\u3053\u3068\u306f\u3042\u308b\u3068\u601d\u3063\u3066\u304a\u308a\u2026 \u305d\u3093\u306a\u3068\u304d\u306b\u6709\u7528\u306a\u3082\u306e\u3092\u307e\u3068\u3081\u307e\u3057\u305f\u3002 1. \u6642\u9593\u306e\u5207\u308a\u4e0a\u3052\u3001\u5207\u308a\u4e0b\u3052 \u4f8b\u3048\u3070\u52e4\u6020\u306e\u6642\u9593\u306f15\u5206\u5358\u4f4d\u3067\u3059\u3088\u3001\u3068\u306a\u3063\u305f\u5834\u5408\u3001 9:08 \u2192 9:15 9:54 \u2192 10:00 \u307e\u305f\u306f 18:38 \u2192 18:30 20:09 \u2192 20:00 \u306e\u3088\u3046\u306b\u3059\u308b\u3057\u305f\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002 \u3084\u308a\u65b9 \u5207\u308a\u4e0a\u3052 =CEILING(A10,\"0:15\") \u5207\u308a\u4e0b\u3052 =FLOOR(A10,\"0:15\") 15\u5206\u5358\u4f4d\u3067\u3001\u3068\u3044\u3046\u306e\u3092\"0:\u2026","author_name":"hrroct","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fhrroct.hatenablog.com%2Fentry%2F2025%2F06%2F08%2F121200\" title=\"\u52e4\u6020\u95a2\u9023\u306eExcel\u95a2\u6570\u96c6 - HRR Co., Ltd.\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_name":"Hatena Blog","provider_url":"https://hatena.blog"}