{"id":20170,"date":"2025-10-27T11:39:15","date_gmt":"2025-10-27T02:39:15","guid":{"rendered":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/?p=20170"},"modified":"2026-03-18T16:03:46","modified_gmt":"2026-03-18T07:03:46","slug":"%e3%82%b9%e3%83%97%e3%83%ac%e3%83%83%e3%83%89%e3%82%b7%e3%83%bc%e3%83%88%e3%81%a7%e6%99%82%e9%96%93%e3%81%ae%e8%b6%b3%e3%81%97%e7%ae%97%e3%82%92%e3%81%99%e3%82%8b%e3%81%ab%e3%81%af%ef%bc%9f24%e6%99%82","status":"publish","type":"post","link":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/20170\/","title":{"rendered":"\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6642\u9593\u306e\u8db3\u3057\u7b97\u3092\u3059\u308b\u306b\u306f\uff1f24\u6642\u9593\u8d85\u3048\u306e\u8a08\u7b97\u304b\u3089\u52e4\u52d9\u6642\u9593\u96c6\u8a08\u307e\u3067\u89e3\u8aac"},"content":{"rendered":"

Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u52e4\u52d9\u6642\u9593\u306e\u96c6\u8a08\u3084\u4f5c\u696d\u6642\u9593\u306e\u5408\u8a08\u3092\u8a08\u7b97\u3059\u308b\u969b\u3001\u6642\u9593\u306e\u8db3\u3057\u7b97\u304c\u6b63\u3057\u304f\u3067\u304d\u305a\u306b\u56f0\u3063\u305f\u7d4c\u9a13\u306f\u3042\u308a\u307e\u305b\u3093\u304b\uff1f<\/p>\n

\u672c\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6642\u9593\u3092\u8db3\u3057\u7b97\u3059\u308b\u57fa\u672c\u7684\u306a\u65b9\u6cd5\u304b\u3089\u300124\u6642\u9593\u3092\u8d85\u3048\u308b\u6642\u9593\u306e\u6b63\u3057\u3044\u8868\u793a\u65b9\u6cd5\u3001\u3055\u3089\u306b\u306f\u8907\u96d1\u306a\u52e4\u52d9\u6642\u9593\u8a08\u7b97\u307e\u3067\u3001\u3059\u3050\u306b\u4f7f\u3048\u308b\u5b9f\u8df5\u7684\u306a\u30c6\u30af\u30cb\u30c3\u30af\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/p>\n

\u5358\u7d14\u306a\u8db3\u3057\u7b97\u6f14\u7b97\u5b50\uff08+\uff09\u306e\u4f7f\u3044\u65b9\u304b\u3089\u3001SUM\u95a2\u6570\u3084TIME\u95a2\u6570\u3092\u6d3b\u7528\u3057\u305f\u6642\u9593\u306e\u52a0\u7b97\u65b9\u6cd5\u307e\u3067\u3001\u3042\u3089\u3086\u308b\u30b1\u30fc\u30b9\u306b\u5bfe\u5fdc\u3067\u304d\u308b\u8a08\u7b97\u624b\u6cd5\u3092\u3001\u5177\u4f53\u4f8b\u3068\u3068\u3082\u306b\u5206\u304b\u308a\u3084\u3059\u304f\u8aac\u660e\u3057\u307e\u3059\u3002<\/p>\n

<\/div>

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6642\u9593\u3092\u8db3\u3057\u7b97\u3059\u308b\u57fa\u672c\u7684\u306a\u65b9\u6cd5\u306f\uff1f<\/h2>\n

\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6642\u9593\u3092\u8db3\u3057\u7b97\u3059\u308b\u6700\u3082\u7c21\u5358\u306a\u65b9\u6cd5\u306f\u3001\u6642\u9593\u5f62\u5f0f\u306e\u30bb\u30eb\u3092\u300c+\u300d\u6f14\u7b97\u5b50\u3067\u8db3\u3059\u304b\u3001SUM\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u81ea\u52d5\u7684\u306b\u6642\u9593\u306e\u5408\u8a08\u304c\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002<\/b><\/span> \u305f\u3060\u3057\u3001\u65e2\u5b9a\u306e\u6642\u523b\u8868\u793a\u3067\u306f 24 \u6642\u9593\u3092\u8d85\u3048\u308b\u3068\u65e5\u4ed8\u306b\u7e70\u308a\u4e0a\u304c\u308a\u3001\u6642\u523b\u90e8\u5206\u3060\u3051\u3092\u898b\u308b\u3068 0:00 \u304b\u3089\u306b\u898b\u3048\u307e\u3059\u3002\u7dcf\u6642\u9593\u3092\u305d\u306e\u307e\u307e\u8868\u793a\u3057\u305f\u3044\u5834\u5408\u306f [h]:mm(:ss) \u306e\u30ab\u30b9\u30bf\u30e0\u8868\u793a\u3092\u8a2d\u5b9a\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n

\u6642\u9593\u306e\u8db3\u3057\u7b97\u306f\u3001\u52e4\u52d9\u6642\u9593\u7ba1\u7406\u3001\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u4f5c\u696d\u6642\u9593\u96c6\u8a08\u3001\u30b9\u30b1\u30b8\u30e5\u30fc\u30eb\u7ba1\u7406\u306a\u3069\u3001\u69d8\u3005\u306a\u5834\u9762\u3067\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u306f\u6642\u9593\u3092\u5185\u90e8\u7684\u306b\u6570\u5024\u3068\u3057\u3066\u6271\u3046\u305f\u3081\u3001\u901a\u5e38\u306e\u6570\u5024\u8a08\u7b97\u3068\u540c\u3058\u3088\u3046\u306b\u6f14\u7b97\u3067\u304d\u307e\u3059\u304c\u3001\u8868\u793a\u5f62\u5f0f\u3092\u9069\u5207\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u304c\u91cd\u8981\u3067\u3059\u30021\u65e5\uff0824\u6642\u9593\uff09\u30921.0\u3068\u3057\u3066\u30011\u6642\u9593\u306f\u7d040.0417\uff081\/24\uff09\u3068\u3044\u3046\u6570\u5024\u3067\u7ba1\u7406\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u6642\u9593\u30c7\u30fc\u30bf\u306e\u6b63\u3057\u3044\u5165\u529b\u65b9\u6cd5\u306f\uff1f<\/h3>\n

\u6642\u9593\u30c7\u30fc\u30bf\u306f\u300c\u6642:\u5206\u300d\u307e\u305f\u306f\u300c\u6642:\u5206:\u79d2\u300d\u306e\u5f62\u5f0f\u3067\u5165\u529b\u3057\u3001Enter\u30ad\u30fc\u3092\u62bc\u3059\u3068\u81ea\u52d5\u7684\u306b\u6642\u9593\u5f62\u5f0f\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u3001\u8a08\u7b97\u53ef\u80fd\u306a\u72b6\u614b\u306b\u306a\u308a\u307e\u3059\u3002<\/b><\/span> \u5165\u529b\u6642\u306e\u30b3\u30ed\u30f3\uff08:\uff09\u306f\u534a\u89d2\u3067\u5165\u529b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u3001\u5168\u89d2\u3067\u306f\u6b63\u3057\u304f\u8a8d\u8b58\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n

\u6642\u9593\u5165\u529b\u306e\u57fa\u672c\u30eb\u30fc\u30eb<\/h4>\n\n\n\n\n\n\n\n\n
\u5165\u529b\u5f62\u5f0f<\/th>\n\u5165\u529b\u4f8b<\/th>\n\u8868\u793a\u7d50\u679c<\/th>\n\u7528\u9014<\/th>\n<\/tr>\n<\/thead>\n
\u6642:\u5206<\/td>\n8:30<\/td>\n8:30:00<\/td>\n\u4e00\u822c\u7684\u306a\u6642\u523b\u30fb\u6642\u9593\u5165\u529b<\/td>\n<\/tr>\n
\u6642:\u5206:\u79d2<\/td>\n14:25:30<\/td>\n14:25:30<\/td>\n\u79d2\u5358\u4f4d\u306e\u7cbe\u5bc6\u306a\u8a18\u9332<\/td>\n<\/tr>\n
\u5206:\u79d2<\/td>\n0:45:30<\/td>\n0:45:30<\/td>\n1\u6642\u9593\u672a\u6e80\u306e\u6642\u9593<\/p>\n

\u203b\u5206:\u79d2\u3092\u5165\u529b\u3059\u308b\u5834\u5408\u306f\u5148\u982d\u306b0\u6642\u9593\u3092\u4ed8\u4e0e\u3057\u307e\u3059\u3002<\/p>\n

\u65e2\u5b9a\u306e\u89e3\u91c8\u306f h:mm(:ss) \u306e\u305f\u3081\u3001\u300c45:30\u300d\u3060\u3051\u3060\u306845\u6642\u959330\u5206\u306b\u306a\u308a\u307e\u3059\u3002<\/td>\n<\/tr>\n

\u65e5 \u6642:\u5206:\u79d2<\/td>\n2 12:30:00<\/td>\n60:30:00<\/td>\n24\u6642\u9593\u8d85\u306e\u5408\u8a08\u3092\u78ba\u5b9f\u306b\u8868\u3059\u65b9\u6cd5\uff1a<\/p>\n

=2 + TIME(12,30,0) \u3092\u5165\u529b\u3057\u3001\u8868\u793a\u5f62\u5f0f\u3092 [h]:mm(:ss) \u306b\u8a2d\u5b9a \u2192 60:30(:00) \u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n

\uff08\u300c2\u300d\u306f2\u65e5\u3092\u610f\u5473\u3002\u8db3\u3057\u7b97\u3067Duration\u3092\u4f5c\u6210\u3059\u308b\u306e\u304c\u78ba\u5b9f\uff09<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n
\u6642\u9593\u5165\u529b\u306e\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3068\u4fbf\u5229\u6a5f\u80fd<\/strong><\/span><\/div>\n
    \n
  1. \u73fe\u5728\u6642\u523b\u306e\u5165\u529b<\/strong>\n
      \n
    • Ctrl + Shift + : \uff08Windows\uff09<\/li>\n
    • Cmd + Shift +\u00a0 ; \uff08Mac\uff09<\/li>\n
    • \u73fe\u5728\u306e\u6642\u523b\u304c\u81ea\u52d5\u5165\u529b\u3055\u308c\u308b<\/li>\n<\/ul>\n<\/li>\n
    • \u6642\u9593\u306e\u81ea\u52d5\u88dc\u5b8c<\/strong>\n
        \n
      • \u300c830\u300d\u300c1430\u300d\u306e\u3088\u3046\u306ahhmm\u5f62\u5f0f\u3092\u6642\u9593\u306b\u5909\u63db<\/strong>\u3059\u308b\u306b\u306f\u6570\u5f0f\u3092\u7528\u3044\u307e\u3059\u3002
        \n\u4f8b\uff1aA1=830 \u2192 =TIME(INT(A1\/100), MOD(A1,100), 0)<\/strong> \u2192 8:30
        \nA1=1430 \u2192 =TIME(INT(A1\/100), MOD(A1,100), 0) <\/strong>\u2192 14:30
        \n\uff08\u5fc5\u8981\u306b\u5fdc\u3058\u3066\u8868\u793a\u5f62\u5f0f\u3092\u300c\u6642\u9593\u300d\u3084[h]:mm\u306b\u8a2d\u5b9a\uff09<\/li>\n<\/ul>\n<\/li>\n
      • \u9023\u7d9a\u3057\u305f\u6642\u9593\u306e\u5165\u529b<\/strong>\n
          \n
        • \u6700\u521d\u306e\u30bb\u30eb\u306b\u6642\u523b\u3092\u5165\u529b<\/li>\n
        • \u30bb\u30eb\u306e\u53f3\u4e0b\u89d2\u3092\u30c9\u30e9\u30c3\u30b0<\/li>\n
        • 1\u6642\u9593\u5358\u4f4d\u3067\u81ea\u52d5\u5897\u5206<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/div>\n

          \u300c+\u300d\u6f14\u7b97\u5b50\u3092\u4f7f\u3063\u305f\u6642\u9593\u306e\u8db3\u3057\u7b97\u306e\u5177\u4f53\u4f8b\u306f\uff1f<\/h2>\n

          \u300c+\u300d\u6f14\u7b97\u5b50\u3092\u4f7f\u3063\u305f\u6642\u9593\u306e\u8db3\u3057\u7b97\u306f\u3001=A1+B1\u306e\u3088\u3046\u306b\u6642\u9593\u304c\u5165\u529b\u3055\u308c\u305f\u30bb\u30eb\u540c\u58eb\u3092\u8db3\u3059\u3060\u3051\u3067\u3001\u81ea\u52d5\u7684\u306b\u6642\u9593\u306e\u5408\u8a08\u304c\u8a08\u7b97\u3055\u308c\u307e\u3059\u3002<\/b><\/span> \u3053\u306e\u65b9\u6cd5\u306f\u6700\u3082\u30b7\u30f3\u30d7\u30eb\u3067\u3001\u5c11\u6570\u306e\u6642\u9593\u3092\u8db3\u3057\u7b97\u3059\u308b\u5834\u5408\u306b\u9069\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

          \u4f8b\u3048\u3070\u3001A1\u30bb\u30eb\u306b\u300c8:30\u300d\u3001B1\u30bb\u30eb\u306b\u300c7:45\u300d\u304c\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u3001C1\u30bb\u30eb\u306b=A1+B1\u3068\u5165\u529b\u3059\u308b\u3068\u3001\u300c16:15\u300d\u3068\u3044\u3046\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u8907\u6570\u306e\u6642\u9593\u3092\u9023\u7d9a\u3057\u3066\u8db3\u3059\u5834\u5408\u306f\u3001=A1+B1+C1+D1\u306e\u3088\u3046\u306b\u6f14\u7b97\u5b50\u3092\u9023\u306d\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n

          \u57fa\u672c\u7684\u306a\u6642\u9593\u306e\u8db3\u3057\u7b97\u306e\u5b9f\u4f8b<\/h3>\n

          2\u3064\u306e\u6642\u9593\u3092\u8db3\u3059\u5834\u5408<\/h4>\n

          A1: 8:30:00\u00a0 \uff088\u6642\u959330\u5206\uff09<\/p>\n

          B1: 7:45:00\u00a0 \uff087\u6642\u959345\u5206\uff09<\/p>\n

          C1: =A1+B1 \u00a0 \uff08\u7d50\u679c\uff1a16:15:00\uff09<\/p>\n

          \u8907\u6570\u306e\u6642\u9593\u3092\u9023\u7d9a\u3057\u3066\u8db3\u3059\u5834\u5408<\/h4>\n

          A1: 3:30:00\u00a0 \uff08\u4f5c\u696d\u6642\u95931\uff09<\/p>\n

          B1: 4:15:00\u00a0 \uff08\u4f5c\u696d\u6642\u95932\uff09<\/p>\n

          C1: 2:45:00\u00a0 \uff08\u4f5c\u696d\u6642\u95933\uff09<\/p>\n

          D1: 5:20:00\u00a0 \uff08\u4f5c\u696d\u6642\u95934\uff09<\/p>\n

          E1: =A1+B1+C1+D1\u00a0 \uff08\u7d50\u679c\uff1a15:50:00\uff09<\/p>\n

          \u6642\u9593\u3068\u5206\u3092\u5225\u3005\u306b\u5165\u529b\u3057\u3066\u8db3\u3059\u5834\u5408<\/h4>\n

          A1: 5\u00a0 \u00a0 \u00a0 \u00a0 \uff08\u6642\u9593\uff09<\/p>\n

          B1: 30 \u00a0 \u00a0 \u00a0 \uff08\u5206\uff09<\/p>\n

          C1: 3\u00a0 \u00a0 \u00a0 \u00a0 \uff08\u8ffd\u52a0\u6642\u9593\uff09<\/p>\n

          D1: 45 \u00a0 \u00a0 \u00a0 \uff08\u8ffd\u52a0\u5206\uff09<\/p>\n

          E1: =TIME(A1+C1, B1+D1, 0)\u00a0 \uff08\u7d50\u679c\uff1a9:15:00\uff09<\/p>\n

          \u56fa\u5b9a\u6642\u9593\u3092\u52a0\u7b97\u3059\u308b\u8a08\u7b97\u65b9\u6cd5\u306f\uff1f<\/h3>\n

          \u56fa\u5b9a\u306e\u6642\u9593\u3092\u52a0\u7b97\u3059\u308b\u5834\u5408\u306f\u3001TIME\u95a2\u6570\u3092\u4f7f\u3063\u3066=A1+TIME(\u6642,\u5206,\u79d2)\u306e\u5f62\u5f0f\u3067\u8a18\u8ff0\u3059\u308b\u304b\u3001\u6642\u9593\u3092\u8868\u3059\u6570\u5024\u3092\u76f4\u63a5\u52a0\u7b97\u3057\u307e\u3059\u3002<\/b><\/span> \u4f8b\u3048\u3070\u3001\u5e38\u306b1\u6642\u959330\u5206\u3092\u52a0\u7b97\u3059\u308b\u5834\u5408\u306e\u8a08\u7b97\u65b9\u6cd5\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n

          TIME\u95a2\u6570\u3092\u4f7f\u3063\u305f\u56fa\u5b9a\u6642\u9593\u306e\u52a0\u7b97<\/h4>\n

          \/\/ 1\u6642\u959330\u5206\u3092\u52a0\u7b97<\/p>\n

          =A1+TIME(1,30,0)<\/p>\n

          \/\/ 45\u5206\u3092\u52a0\u7b97<\/p>\n

          =A1+TIME(0,45,0)<\/p>\n

          \/\/ 2\u6642\u959315\u520630\u79d2\u3092\u52a0\u7b97<\/p>\n

          =A1+TIME(2,15,30)<\/p>\n

          \u6570\u5024\u3068\u3057\u3066\u6642\u9593\u3092\u52a0\u7b97\u3059\u308b\u65b9\u6cd5<\/h4>\n

          \/\/ 1\u6642\u9593\u3092\u52a0\u7b97\uff081\u6642\u9593 = 1\/24\uff09<\/p>\n

          =A1+1\/24<\/p>\n

          \/\/ 30\u5206\u3092\u52a0\u7b97\uff0830\u5206 = 0.5\/24\uff09<\/p>\n

          =A1+0.5\/24<\/p>\n

          \/\/ 90\u5206\u3092\u52a0\u7b97\uff0890\u5206 = 1.5\/24\uff09<\/p>\n

          =A1+1.5\/24<\/p>\n

          \/\/ \u4efb\u610f\u306e\u5206\u6570\u3092\u52a0\u7b97\u3059\u308b\u6c4e\u7528\u5f0f<\/p>\n

          =A1+\u5206\u6570\/1440\u00a0 \uff081440 = 24\u6642\u9593\u00d760\u5206\uff09<\/p>\n

          \u6642\u523b\u3068\u7d4c\u904e\u6642\u9593\u3092\u8db3\u3057\u7b97\u3059\u308b\u5834\u5408\u306e\u6ce8\u610f\u70b9\u306f\uff1f<\/h3>\n

          \u6642\u523b\uff08\u7279\u5b9a\u306e\u6642\u70b9\uff09\u3068\u7d4c\u904e\u6642\u9593\uff08\u671f\u9593\uff09\u3092\u8db3\u3059\u5834\u5408\u306f\u3001\u4e21\u65b9\u304c\u540c\u3058\u6642\u9593\u5f62\u5f0f\u3067\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u3001\u65e5\u4ed8\u3092\u307e\u305f\u3050\u8a08\u7b97\u3067\u306f\u8868\u793a\u5f62\u5f0f\u306e\u8abf\u6574\u304c\u5fc5\u8981\u3067\u3059\u3002<\/b><\/span> \u7279\u306b\u3001\u7d42\u4e86\u6642\u523b\u304c\u7fcc\u65e5\u306b\u306a\u308b\u5834\u5408\u306e\u51e6\u7406\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3059\u3002<\/p>\n

          \u958b\u59cb\u6642\u523b\u306b\u4f5c\u696d\u6642\u9593\u3092\u52a0\u7b97<\/h4>\n

          A1: 9:00:00 \u00a0 \uff08\u958b\u59cb\u6642\u523b\uff09<\/p>\n

          B1: 8:30:00 \u00a0 \uff08\u4f5c\u696d\u6642\u9593\uff09<\/p>\n

          C1: =A1+B1\u00a0 \u00a0 \uff08\u7d42\u4e86\u6642\u523b\uff1a17:30:00\uff09<\/p>\n

          \/\/ \u65e5\u4ed8\u3092\u307e\u305f\u3050\u5834\u5408<\/p>\n

          A1: 20:00:00\u00a0 \uff08\u958b\u59cb\u6642\u523b\uff09<\/p>\n

          B1: 6:00:00 \u00a0 \uff08\u4f5c\u696d\u6642\u9593\uff09<\/p>\n

          C1: =A1+B1\u00a0 \u00a0 \uff08\u7d50\u679c\uff1a2:00:00 \u2190 \u7fcc\u65e52\u6642\uff09<\/p>\n

          \/\/ \u6b63\u3057\u304f\u8868\u793a\u3059\u308b\u306b\u306f\u65e5\u4ed8\u3082\u542b\u3081\u308b\u5fc5\u8981\u304c\u3042\u308b<\/p>\n

          \u65e5\u4ed8\u3092\u307e\u305f\u3050\u8a08\u7b97\u306e\u5bfe\u51e6\u6cd5<\/h4>\n

          \/\/ \u65b9\u6cd51\uff1a\u6761\u4ef6\u5f0f\u3067\u7fcc\u65e5\u5224\u5b9a<\/p>\n

          =IF(A1+B1<A1, A1+B1+1, A1+B1)<\/p>\n

          \/\/ \u65b9\u6cd52\uff1aMOD\u95a2\u6570\u306724\u6642\u9593\u5185\u306b\u53ce\u3081\u308b<\/p>\n

          =MOD(A1+B1, 1)<\/p>\n

          \/\/ \u65b9\u6cd53\uff1a\u65e5\u4ed8\u4ed8\u304d\u3067\u7ba1\u7406\uff08\u7fcc\u65e5\u5224\u5b9a\u3092\u660e\u793a\uff09<\/p>\n

          A1: 2025\/1\/15 20:00:00 \/\/ \u958b\u59cb\u65e5\u6642\uff08\u65e5\u6642\u3068\u3057\u3066\u5165\u529b\uff09<\/p>\n

          B1: 6:00:00 \/\/ \u4f5c\u696d\u6642\u9593\uff08\u6642\u9593:\u5206:\u79d2\u3001\u671f\u9593\u3068\u3057\u3066\u5165\u529b\uff09<\/p>\n

          C1: =A1 + B1 \/\/ \u7d42\u4e86\u65e5\u6642\uff08\u7d50\u679c\uff1a2025\/1\/16 2:00:00\uff09<\/p>\n

          \n
          \u8868\u793a\u5f62\u5f0f\u306e\u4f8b<\/strong><\/span><\/div>\n
            \n
          • \u7d42\u4e86\u65e5\u6642\u3092\u65e5\u6642\u3067\u8868\u793a \u2192 yyyy\/m\/d h:mm<\/li>\n
          • \u300c\u7fcc\u65e5\u300d\u306a\u3069\u306e\u6587\u8a00\u3082\u51fa\u3057\u305f\u3044 \u2192 =IF(INT(C1)>INT(A1),”\u7fcc\u65e5”,”\u540c\u65e5”)&TEXT(C1,” h:mm”)
            \n\u203b \u6642\u523b\u3060\u3051\u306b\u4e38\u3081\u305f\u3044\u5834\u5408\u306f =MOD(A1+B1,1)\uff08\u7fcc\u65e5\u306b\u7e70\u308a\u4e0a\u304c\u308b\u60c5\u5831\u306f\u8868\u793a\u4e0a\u5931\u308f\u308c\u307e\u3059\uff09\u3002<\/li>\n<\/ul>\n<\/div>\n

            SUM\u95a2\u6570\u3092\u4f7f\u3063\u305f\u6642\u9593\u306e\u5408\u8a08\u8a08\u7b97\u306e\u65b9\u6cd5\u306f\uff1f<\/h2>\n

            SUM\u95a2\u6570\u3092\u4f7f\u3063\u305f\u6642\u9593\u306e\u5408\u8a08\u306f=SUM(\u7bc4\u56f2)\u3067\u7c21\u5358\u306b\u8a08\u7b97\u3067\u304d\u3001\u5927\u91cf\u306e\u6642\u9593\u30c7\u30fc\u30bf\u3092\u4e00\u62ec\u3067\u8db3\u3057\u7b97\u3059\u308b\u969b\u306b\u6700\u3082\u52b9\u7387\u7684\u306a\u65b9\u6cd5\u3067\u3059\u3002<\/b><\/span> \u7bc4\u56f2\u6307\u5b9a\u306b\u3088\u308a\u3001\u8ffd\u52a0\u3084\u524a\u9664\u304c\u3042\u3063\u3066\u3082\u81ea\u52d5\u7684\u306b\u5408\u8a08\u304c\u66f4\u65b0\u3055\u308c\u308b\u5229\u70b9\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n

            SUM\u95a2\u6570\u306f\u3001\u9023\u7d9a\u3057\u305f\u7bc4\u56f2\u3060\u3051\u3067\u306a\u304f\u3001\u96e2\u308c\u305f\u8907\u6570\u306e\u7bc4\u56f2\u3084\u500b\u5225\u306e\u30bb\u30eb\u3082\u540c\u6642\u306b\u5408\u8a08\u3067\u304d\u307e\u3059\u3002\u307e\u305f\u3001\u6761\u4ef6\u4ed8\u304d\u306e\u5408\u8a08\u304c\u5fc5\u8981\u306a\u5834\u5408\u306f\u3001SUMIF\u95a2\u6570\u3084SUMIFS\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u6642\u9593\u3060\u3051\u3092\u5408\u8a08\u3059\u308b\u3053\u3068\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n

            \u57fa\u672c\u7684\u306aSUM\u95a2\u6570\u3067\u306e\u6642\u9593\u5408\u8a08\u306e\u5b9f\u4f8b<\/h3>\n

            \u9023\u7d9a\u7bc4\u56f2\u306e\u6642\u9593\u5408\u8a08<\/h4>\n

            A1: 8:30:00 \u00a0 \uff08\u6708\u66dc\u65e5\uff09<\/p>\n

            A2: 7:45:00 \u00a0 \uff08\u706b\u66dc\u65e5\uff09<\/p>\n

            A3: 9:15:00 \u00a0 \uff08\u6c34\u66dc\u65e5\uff09<\/p>\n

            A4: 8:00:00 \u00a0 \uff08\u6728\u66dc\u65e5\uff09<\/p>\n

            A5: 7:30:00 \u00a0 \uff08\u91d1\u66dc\u65e5\uff09<\/p>\n

            A6: =SUM(A1:A5)\u00a0 \uff08\u5408\u8a08\uff1a41:00:00 \u203b\u8981\u66f8\u5f0f\u8a2d\u5b9a\uff09<\/p>\n

            \u8907\u6570\u7bc4\u56f2\u306e\u6642\u9593\u5408\u8a08<\/h4>\n

            \/\/ \u5348\u524d\u3068\u5348\u5f8c\u306e\u4f5c\u696d\u6642\u9593\u3092\u5225\u3005\u306b\u8a18\u9332<\/p>\n

            B\u5217\uff08\u5348\u524d\uff09: 4:00, 3:30, 4:00, 3:45, 4:00<\/p>\n

            C\u5217\uff08\u5348\u5f8c\uff09: 4:30, 4:00, 3:45, 4:15, 3:30<\/p>\n

            \/\/ \u4e21\u65b9\u3092\u5408\u8a08<\/p>\n

            =SUM(B1:B5, C1:C5)\u00a0 \uff08\u7d50\u679c\uff1a39:15:00\uff09<\/p>\n

            \u98db\u3073\u98db\u3073\u306e\u30bb\u30eb\u3092\u5408\u8a08<\/h4>\n

            =SUM(A1, A3, A5, B2, B4)\u00a0 \/\/ \u7279\u5b9a\u306e\u30bb\u30eb\u306e\u307f\u5408\u8a08<\/p>\n

            SUMIF\u95a2\u6570\u3067\u6761\u4ef6\u4ed8\u304d\u6642\u9593\u5408\u8a08\u3092\u8a08\u7b97\u3059\u308b\u306b\u306f\uff1f<\/h3>\n

            SUMIF\u95a2\u6570\u3092\u4f7f\u3048\u3070\u3001=SUMIF(\u6761\u4ef6\u7bc4\u56f2, \u6761\u4ef6, \u5408\u8a08\u7bc4\u56f2)\u306e\u5f62\u5f0f\u3067\u3001\u7279\u5b9a\u306e\u6761\u4ef6\u3092\u6e80\u305f\u3059\u884c\u306e\u6642\u9593\u3060\u3051\u3092\u5408\u8a08\u3067\u304d\u307e\u3059\u3002<\/b><\/span> \u4f8b\u3048\u3070\u3001\u7279\u5b9a\u306e\u62c5\u5f53\u8005\u306e\u4f5c\u696d\u6642\u9593\u3084\u3001\u7279\u5b9a\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306e\u6642\u9593\u3060\u3051\u3092\u96c6\u8a08\u3059\u308b\u5834\u5408\u306b\u4fbf\u5229\u3067\u3059\u3002<\/p>\n

            \u6761\u4ef6\u4ed8\u304d\u6642\u9593\u5408\u8a08\u306e\u5b9f\u4f8b<\/h4>\n

            A\u5217\uff08\u62c5\u5f53\u8005\uff09 | B\u5217\uff08\u4f5c\u696d\u6642\u9593\uff09<\/p>\n

            1\u00a0 \u7530\u4e2d\u00a0 \u00a0 \u00a0 \u00a0 | 3:30:00<\/p>\n

            2\u00a0 \u9234\u6728\u00a0 \u00a0 \u00a0 \u00a0 | 4:15:00<\/p>\n

            3\u00a0 \u7530\u4e2d\u00a0 \u00a0 \u00a0 \u00a0 | 2:45:00<\/p>\n

            4\u00a0 \u4f50\u85e4\u00a0 \u00a0 \u00a0 \u00a0 | 5:00:00<\/p>\n

            5\u00a0 \u7530\u4e2d\u00a0 \u00a0 \u00a0 \u00a0 | 3:15:00<\/p>\n

            \/\/ \u7530\u4e2d\u3055\u3093\u306e\u4f5c\u696d\u6642\u9593\u5408\u8a08<\/p>\n

            =SUMIF(A1:A5, “\u7530\u4e2d”, B1:B5)\u00a0 \uff08\u7d50\u679c\uff1a9:30:00\uff09<\/p>\n

            \/\/ 3\u6642\u9593\u4ee5\u4e0a\u306e\u4f5c\u696d\u6642\u9593\u306e\u5408\u8a08<\/p>\n

            =SUMIF(B1:B5, “>=” & **TIME(3,0,0)**, B1:B5) \uff08\u7d50\u679c\uff1a15:45:00\uff09<\/p>\n

            SUMIFS\u95a2\u6570\u3067\u8907\u6570\u6761\u4ef6\u306e\u6642\u9593\u5408\u8a08<\/h4>\n

            A\u5217\uff08\u65e5\u4ed8\uff09 \u00a0 | B\u5217\uff08\u62c5\u5f53\u8005\uff09 | C\u5217\uff08\u7a2e\u5225\uff09 | D\u5217\uff08\u6642\u9593\uff09<\/p>\n

            1\u00a0 2025\/1\/15 \u00a0 | \u7530\u4e2d\u00a0 \u00a0 \u00a0 \u00a0 | \u4f1a\u8b70\u00a0 \u00a0 \u00a0 | 2:00:00<\/p>\n

            2\u00a0 2025\/1\/15 \u00a0 | \u7530\u4e2d\u00a0 \u00a0 \u00a0 \u00a0 | \u4f5c\u696d\u00a0 \u00a0 \u00a0 | 4:00:00<\/p>\n

            3\u00a0 2025\/1\/16 \u00a0 | \u7530\u4e2d\u00a0 \u00a0 \u00a0 \u00a0 | \u4f1a\u8b70\u00a0 \u00a0 \u00a0 | 1:30:00<\/p>\n

            4\u00a0 2025\/1\/16 \u00a0 | \u9234\u6728\u00a0 \u00a0 \u00a0 \u00a0 | \u4f5c\u696d\u00a0 \u00a0 \u00a0 | 3:00:00<\/p>\n

            \/\/ \u7530\u4e2d\u3055\u3093\u306e\u4f5c\u696d\u6642\u9593\u306e\u307f\u5408\u8a08<\/p>\n

            =SUMIFS(D1:D4, B1:B4, “\u7530\u4e2d”, C1:C4, “\u4f5c\u696d”)\u00a0 \uff08\u7d50\u679c\uff1a4:00:00\uff09<\/p>\n

            \/\/ 1\/15\u306e\u5168\u4f5c\u696d\u6642\u9593<\/p>\n

            =SUMIFS(D1:D4, A1:A4, DATE(2025,1,15))\u00a0 \uff08\u7d50\u679c\uff1a6:00:00\uff09<\/p>\n

            \u914d\u5217\u6570\u5f0f\u3067\u52d5\u7684\u306a\u6642\u9593\u5408\u8a08\u3092\u4f5c\u6210\u3059\u308b\u65b9\u6cd5\u306f\uff1f<\/h3>\n

            \u914d\u5217\u6570\u5f0f\u3068ARRAYFORMULA\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u81ea\u52d5\u7684\u306b\u62e1\u5f35\u3055\u308c\u308b\u52d5\u7684\u306a\u6642\u9593\u5408\u8a08\u3092\u4f5c\u6210\u3067\u304d\u3001\u30c7\u30fc\u30bf\u304c\u8ffd\u52a0\u3055\u308c\u3066\u3082\u6570\u5f0f\u306e\u4fee\u6b63\u304c\u4e0d\u8981\u306b\u306a\u308a\u307e\u3059\u3002<\/b><\/span> \u3053\u308c\u306f\u3001\u983b\u7e41\u306b\u30c7\u30fc\u30bf\u304c\u66f4\u65b0\u3055\u308c\u308b\u74b0\u5883\u3067\u7279\u306b\u6709\u52b9\u3067\u3059\u3002<\/p>\n

            \u52d5\u7684\u306a\u7d2f\u8a08\u6642\u9593\u306e\u8a08\u7b97<\/h4>\n

            \/\/ A\u5217\u306b\u6642\u9593\u30c7\u30fc\u30bf\u3001B\u5217\u306b\u7d2f\u8a08\u3092\u81ea\u52d5\u8a08\u7b97<\/p>\n

            B1: =ARRAYFORMULA(IF(A1:A=””,””,SUMIF(ROW(A1:A),”<=”&ROW(A1:A),A1:A)))<\/p>\n

            \/\/ \u7d50\u679c\uff1a<\/p>\n

            A\u5217\u00a0 \u00a0 \u00a0 \u00a0 | B\u5217\uff08\u7d2f\u8a08\uff09<\/p>\n

            3:00:00 \u00a0 | 3:00:00<\/p>\n

            2:30:00 \u00a0 | 5:30:00<\/p>\n

            4:00:00 \u00a0 | 9:30:00<\/p>\n

            \uff08\u65b0\u898f\u8ffd\u52a0\uff09| \uff08\u81ea\u52d5\u8a08\u7b97\uff09<\/p>\n

            \u9031\u5358\u4f4d\u3067\u306e\u81ea\u52d5\u96c6\u8a08<\/h4>\n

            \/\/ A\u5217\uff1a\u65e5\u4ed8\u3001B\u5217\uff1a\u4f5c\u696d\u6642\u9593\u3001C\u5217\uff1a\u9031\u5408\u8a08<\/p>\n

            C1: =ARRAYFORMULA(IF(WEEKDAY(A1:A)=1,<\/p>\n

            SUMIFS(B:B,A:A,”>=”&A1:A-6,A:A,”<=”&A1:A),””))<\/p>\n

            \/\/ \u65e5\u66dc\u65e5\u306e\u30bb\u30eb\u306b\u81ea\u52d5\u7684\u306b\u305d\u306e\u9031\u306e\u5408\u8a08\u304c\u8868\u793a\u3055\u308c\u308b<\/p>\n

            TIME\u95a2\u6570\u3068TIMEVALUE\u95a2\u6570\u3067\u6642\u9593\u3092\u64cd\u4f5c\u3059\u308b\u65b9\u6cd5\u306f\uff1f<\/h2>\n

            TIME\u95a2\u6570\u306f\u6570\u5024\u304b\u3089\u6642\u9593\u3092\u751f\u6210\u3057\u3001TIMEVALUE\u95a2\u6570\u306f\u6587\u5b57\u5217\u3092\u6642\u9593\u306b\u5909\u63db\u3059\u308b\u95a2\u6570\u3067\u3001\u3053\u308c\u3089\u3092\u4f7f\u3046\u3053\u3068\u3067\u67d4\u8edf\u306a\u6642\u9593\u306e\u8db3\u3057\u7b97\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/b><\/span> \u7279\u306b\u3001\u5916\u90e8\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u3084\u3001\u6642\u30fb\u5206\u30fb\u79d2\u304c\u5225\u3005\u306e\u30bb\u30eb\u306b\u5165\u529b\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306b\u6709\u52b9\u3067\u3059\u3002<\/p>\n

            TIME\u95a2\u6570\u306fTIME(\u6642, \u5206, \u79d2)\u306e\u5f62\u5f0f\u3067\u3001\u500b\u5225\u306e\u6570\u5024\u304b\u3089\u6642\u9593\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002TIMEVALUE\u95a2\u6570\u306fTIMEVALUE(“\u6642\u9593\u6587\u5b57\u5217”)\u306e\u5f62\u5f0f\u3067\u3001\u30c6\u30ad\u30b9\u30c8\u5f62\u5f0f\u306e\u6642\u9593\u3092\u8a08\u7b97\u53ef\u80fd\u306a\u6642\u9593\u5024\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u308b\u3053\u3068\u3067\u3001\u69d8\u3005\u306a\u5f62\u5f0f\u306e\u30c7\u30fc\u30bf\u304b\u3089\u6642\u9593\u8a08\u7b97\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

            TIME\u95a2\u6570\u3067\u6642\u9593\u3092\u751f\u6210\u3057\u3066\u8db3\u3057\u7b97\u3059\u308b\u5b9f\u4f8b<\/h3>\n

            \u6642\u30fb\u5206\u30fb\u79d2\u304b\u3089\u6642\u9593\u3092\u4f5c\u6210<\/h4>\n

            A1: 8\u00a0 \uff08\u6642\uff09<\/p>\n

            B1: 30 \uff08\u5206\uff09<\/p>\n

            C1: 45 \uff08\u79d2\uff09<\/p>\n

            D1: =TIME(A1, B1, C1)\u00a0 \uff08\u7d50\u679c\uff1a8:30:45\uff09<\/p>\n

            \/\/ \u5225\u306e\u6642\u9593\u3068\u8db3\u3057\u7b97<\/p>\n

            E1: 2:15:00<\/p>\n

            F1: =D1+E1\u00a0 \uff08\u7d50\u679c\uff1a10:45:45\uff09<\/p>\n

            \u52d5\u7684\u306a\u6642\u9593\u751f\u6210\u3068\u8a08\u7b97<\/h4>\n

            \/\/ \u73fe\u5728\u6642\u523b\u306b\u6307\u5b9a\u6642\u9593\u3092\u52a0\u7b97<\/p>\n

            =NOW()+TIME(2,30,0)\u00a0 \/\/ \u73fe\u5728\u304b\u30892\u6642\u959330\u5206\u5f8c<\/p>\n

            \/\/ \u6761\u4ef6\u306b\u5fdc\u3058\u305f\u6642\u9593\u52a0\u7b97<\/p>\n

            =A1+TIME(IF(B1=”\u6025\u304e”,1,2), 0, 0)\u00a0 \/\/ \u6025\u304e\u306a\u30891\u6642\u9593\u3001\u901a\u5e38\u306f2\u6642\u9593\u52a0\u7b97<\/p>\n

            \u5206\u5358\u4f4d\u306e\u6570\u5024\u3092\u6642\u9593\u306b\u5909\u63db\u3057\u3066\u52a0\u7b97<\/h4>\n

            A1: 150\u00a0 \uff08\u5206\u5358\u4f4d\u306e\u4f5c\u696d\u6642\u9593\uff09<\/p>\n

            B1: 45 \u00a0 \uff08\u8ffd\u52a0\u306e\u5206\u6570\uff09<\/p>\n

            C1: =TIME(0, A1+B1, 0)\u00a0 \uff08\u7d50\u679c\uff1a3:15:00\uff09<\/p>\n

            \/\/ \u307e\u305f\u306f\u9664\u7b97\u3092\u4f7f\u7528<\/p>\n

            D1: =(A1+B1)\/1440\u00a0 \/\/ \u66f8\u5f0f\u3092\u6642\u9593\u306b\u8a2d\u5b9a<\/p>\n

            TIMEVALUE\u95a2\u6570\u3067\u6587\u5b57\u5217\u3092\u6642\u9593\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\u306f\uff1f<\/h3>\n

            TIMEVALUE\u95a2\u6570\u306f\u3001=TIMEVALUE(“8:30 AM”)\u306e\u3088\u3046\u306b\u6587\u5b57\u5217\u5f62\u5f0f\u306e\u6642\u9593\u3092\u6570\u5024\u306b\u5909\u63db\u3057\u3001\u8a08\u7b97\u53ef\u80fd\u306b\u3059\u308b\u95a2\u6570\u3067\u3001\u5916\u90e8\u30c7\u30fc\u30bf\u306e\u53d6\u308a\u8fbc\u307f\u6642\u306b\u7279\u306b\u6709\u7528\u3067\u3059\u3002<\/b><\/span> CSV\u30d5\u30a1\u30a4\u30eb\u3084Web\u304b\u3089\u30b3\u30d4\u30fc\u3057\u305f\u30c7\u30fc\u30bf\u306e\u6642\u9593\u8a08\u7b97\u306b\u4e0d\u53ef\u6b20\u3067\u3059\u3002<\/p>\n

            \u6587\u5b57\u5217\u6642\u9593\u306e\u5909\u63db\u3068\u8a08\u7b97<\/h4>\n

            A1: “8:30 AM”\u00a0 \uff08\u6587\u5b57\u5217\uff09<\/p>\n

            B1: “2:45 PM”\u00a0 \uff08\u6587\u5b57\u5217\uff09<\/p>\n

            C1: =TIMEVALUE(A1)\u00a0 \uff08\u7d50\u679c\uff1a0.354166… \u2192 8:30:00\u8868\u793a\uff09<\/p>\n

            D1: =TIMEVALUE(B1)\u00a0 \uff08\u7d50\u679c\uff1a0.614583… \u2192 14:45:00\u8868\u793a\uff09<\/p>\n

            E1: =D1-C1\u00a0 \uff08\u7d4c\u904e\u6642\u9593\uff1a6:15:00\uff09<\/p>\n

            \u69d8\u3005\u306a\u5f62\u5f0f\u306e\u6587\u5b57\u5217\u3092\u5909\u63db<\/h4>\n

            \/\/ \u57fa\u672c\u7684\u306a\u5909\u63db<\/p>\n

            =TIMEVALUE(“14:30”)\u00a0 \u00a0 \u00a0 \/\/ 14:30:00<\/p>\n

            =TIMEVALUE(“2:30 PM”)\u00a0 \u00a0 \/\/ 14:30:00<\/p>\n

            =TIMEVALUE(“14:30:45″) \u00a0 \/\/ 14:30:45<\/p>\n

            \/\/ \u30a8\u30e9\u30fc\u51e6\u7406\u3092\u542b\u3080\u5909\u63db<\/p>\n

            =IFERROR(TIMEVALUE(A1), TIME(0,0,0))\u00a0 \/\/ \u5909\u63db\u3067\u304d\u306a\u3044\u5834\u5408\u306f0:00<\/p>\n

            \/\/ \u65e5\u672c\u8a9e\u8868\u8a18\u306e\u5909\u63db\uff08\u8981\u52a0\u5de5\uff09<\/p>\n

            =TIMEVALUE(SUBSTITUTE(SUBSTITUTE(A1,”\u6642”,”:”),”\u5206”,””))<\/p>\n

            \/\/ “8\u664230\u5206” \u2192 “8:30” \u2192 8:30:00<\/p>\n

            HOUR\u3001MINUTE\u3001SECOND\u95a2\u6570\u3092\u7d44\u307f\u5408\u308f\u305b\u305f\u8a08\u7b97\u65b9\u6cd5\u306f\uff1f<\/h3>\n

            HOUR\u3001MINUTE\u3001SECOND\u95a2\u6570\u3067\u6642\u9593\u3092\u69cb\u6210\u8981\u7d20\u306b\u5206\u89e3\u3057\u3001\u500b\u5225\u306b\u8a08\u7b97\u3057\u3066\u304b\u3089TIME\u95a2\u6570\u3067\u518d\u69cb\u7bc9\u3059\u308b\u3053\u3068\u3067\u3001\u8907\u96d1\u306a\u6642\u9593\u8a08\u7b97\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/b><\/span> \u3053\u306e\u65b9\u6cd5\u306f\u3001\u7279\u5b9a\u306e\u5358\u4f4d\u3067\u306e\u7aef\u6570\u51e6\u7406\u3084\u8abf\u6574\u304c\u5fc5\u8981\u306a\u5834\u5408\u306b\u6709\u52b9\u3067\u3059\u3002<\/p>\n

            \u6642\u9593\u306e\u5206\u89e3\u3068\u518d\u69cb\u7bc9<\/h4>\n

            A1: 8:45:30\u00a0 \uff08\u5143\u306e\u6642\u9593\uff09<\/p>\n

            \/\/ \u5404\u8981\u7d20\u3092\u53d6\u5f97<\/p>\n

            B1: =HOUR(A1)\u00a0 \u00a0 \uff08\u7d50\u679c\uff1a8\uff09<\/p>\n

            C1: =MINUTE(A1)\u00a0 \uff08\u7d50\u679c\uff1a45\uff09<\/p>\n

            D1: =SECOND(A1)\u00a0 \uff08\u7d50\u679c\uff1a30\uff09<\/p>\n

            \/\/ 30\u5206\u5358\u4f4d\u3067\u5207\u308a\u4e0a\u3052\uff08\u79d2\u3082\u8003\u616e\u30fb\u7c21\u6f54\uff09<\/p>\n

            E1: =CEILING(A1, TIME(0,30,0))<\/p>\n

            \/\/ \u7d50\u679c\uff1a9:00:00<\/p>\n

            \/\/ 15\u5206\u5358\u4f4d\u3067\u56db\u6368\u4e94\u5165<\/p>\n

            F1: =MROUND(A1, TIME(0,15,0))<\/p>\n

            \/\/ 15\u5206\u5358\u4f4d\u3067\u5207\u308a\u4e0a\u3052\uff08\u5fc5\u8981\u306a\u3089\u3053\u3061\u3089\uff09<\/p>\n

            F1: =CEILING(A1, TIME(0,15,0))<\/p>\n

            \/\/ \u7d50\u679c\uff1a9:00:00<\/p>\n

            \u8907\u96d1\u306a\u6642\u9593\u8a08\u7b97\u306e\u4f8b<\/h4>\n

            \/\/ \u6b8b\u696d\u6642\u9593\u306e\u8a08\u7b97\uff08\u5b9a\u6642\uff1a17:30\uff09<\/p>\n

            A1: 20:45:00\u00a0 \uff08\u7d42\u696d\u6642\u523b\uff09<\/p>\n

            B1: =IF(A1>TIME(17,30,0), A1-TIME(17,30,0), 0)<\/p>\n

            \/\/ \u7d50\u679c\uff1a3:15:00<\/p>\n

            \/\/ \u6df1\u591c\u624b\u5f53\u5bfe\u8c61\u6642\u9593\uff0822:00\u4ee5\u964d\uff09<\/p>\n

            C1: =IF(A1>TIME(22,0,0), A1-TIME(22,0,0), 0)<\/p>\n

            \/\/ \u7d50\u679c\uff1a0:00:00\uff0820:45\u306f22:00\u524d\uff09<\/p>\n

            \/\/ \u6642\u9593\u3092\u5206\u5358\u4f4d\u306e\u6570\u5024\u306b\u5909\u63db<\/p>\n

            D1: =HOUR(A1)*60+MINUTE(A1)+SECOND(A1)\/60<\/p>\n

            \/\/ \u7d50\u679c\uff1a1245\uff08\u5206\uff09<\/p>\n

            24\u6642\u9593\u3092\u8d85\u3048\u308b\u6642\u9593\u306e\u8db3\u3057\u7b97\u3092\u6b63\u3057\u304f\u8868\u793a\u3059\u308b\u306b\u306f\uff1f<\/h2>\n

            24\u6642\u9593\u3092\u8d85\u3048\u308b\u6642\u9593\u3092\u6b63\u3057\u304f\u8868\u793a\u3059\u308b\u306b\u306f\u3001\u30bb\u30eb\u306e\u66f8\u5f0f\u3092[h]:mm:ss\u306b\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u3067\u300125:30:00\u306e\u3088\u3046\u306b24\u6642\u9593\u4ee5\u4e0a\u306e\u6642\u9593\u3082\u6b63\u78ba\u306b\u8868\u793a\u3067\u304d\u307e\u3059\u3002 <\/b><\/span>\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u6642\u9593\u5f62\u5f0f\u3067\u306f\u300124\u6642\u9593\u3092\u8d85\u3048\u308b\u30680\u306b\u30ea\u30bb\u30c3\u30c8\u3055\u308c\u3066\u3057\u307e\u3046\u305f\u3081\u3001\u3053\u306e\u8a2d\u5b9a\u306f\u5fc5\u9808\u3067\u3059\u3002<\/p>\n

            \u4f8b\u3048\u3070\u3001\u9031\u9593\u306e\u52e4\u52d9\u6642\u9593\u5408\u8a08\u304c40\u6642\u9593\u306e\u5834\u5408\u3001\u901a\u5e38\u306e\u6642\u9593\u5f62\u5f0f\u3067\u306f\u300c16:00:00\u300d\u3068\u8868\u793a\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u304c\u3001[h]:mm\u5f62\u5f0f\u306b\u3059\u308b\u3053\u3068\u3067\u300c40:00\u300d\u3068\u6b63\u3057\u304f\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u89d2\u62ec\u5f27[]\u304c\u91cd\u8981\u3067\u3001\u3053\u308c\u306b\u3088\u308a\u6642\u9593\u306e\u7d2f\u7a4d\u8868\u793a\u304c\u53ef\u80fd\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n

            24\u6642\u9593\u8d85\u306e\u8868\u793a\u5f62\u5f0f\u3092\u8a2d\u5b9a\u3059\u308b\u624b\u9806<\/h3>\n
            \n
            \u30ab\u30b9\u30bf\u30e0\u6570\u5024\u5f62\u5f0f\u306e\u8a2d\u5b9a\u65b9\u6cd5<\/strong><\/span><\/div>\n
              \n
            1. \u5bfe\u8c61\u30bb\u30eb\u3092\u9078\u629e<\/strong><\/li>\n
            2. \u300c\u8868\u793a\u5f62\u5f0f\u300d\u2192\u300c\u6570\u5b57\u300d\u2192\u300c\u30ab\u30b9\u30bf\u30e0\u6570\u5024\u5f62\u5f0f\u300d<\/strong><\/li>\n
            3. \u4ee5\u4e0b\u306e\u66f8\u5f0f\u30b3\u30fc\u30c9\u304b\u3089\u9078\u629e\u3057\u3066\u5165\u529b<\/strong><\/li>\n<\/ol>\n<\/div>\n\n\n\n\n\n\n\n\n\n\n
              \u66f8\u5f0f\u30b3\u30fc\u30c9<\/th>\n\u8868\u793a\u4f8b<\/th>\n\u7528\u9014<\/th>\n<\/tr>\n<\/thead>\n
              [h]:mm<\/td>\n40:30<\/td>\n\u6642\u9593\u3068\u5206\u306e\u8868\u793a<\/td>\n<\/tr>\n
              [h]:mm:ss<\/td>\n40:30:15<\/td>\n\u79d2\u307e\u3067\u542b\u3080\u8a73\u7d30\u8868\u793a<\/td>\n<\/tr>\n
              [h]”\u6642\u9593”mm”\u5206”<\/td>\n40\u6642\u959330\u5206<\/td>\n\u65e5\u672c\u8a9e\u8868\u8a18<\/td>\n<\/tr>\n
              [h]”h “mm”m”<\/td>\n40h 30m<\/td>\n\u82f1\u8a9e\u7565\u8a18<\/td>\n<\/tr>\n
              [m]”\u5206”<\/td>\n2430\u5206<\/td>\n\u5206\u5358\u4f4d\u3067\u306e\u7dcf\u8a08\u8868\u793a<\/td>\n<\/tr>\n
              #,##0″\u6642\u9593”<\/td>\n40\u6642\u9593<\/td>\n\u6642\u9593\u306e\u307f\uff08\u7aef\u6570\u5207\u308a\u6368\u3066\uff09\u3092\u8868\u793a\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u8a08\u7b97\u5f0f\u3067\u6642\u9593\u6570\u306b\u5909\u63db\u3057\u3066\u304b\u3089\u8868\u793a<\/strong>\u3057\u307e\u3059\u3002<\/p>\n

              \u4f8b\uff1a<\/p>\n

                \n
              • \u7dcf\u300c\u6642\u9593\u6570\u300d\u306e\u6574\u6570\u8868\u793a \u2192 =INT(A1*24)&”\u6642\u9593”<\/li>\n
              • \u5c0f\u65701\u6841\u306e\u6642\u9593\u8868\u793a \u2192 =ROUND(A1*24,1)&”\u6642\u9593”
                \n\u203b\u300c\u6642\u9593\u306e\u307e\u307e\u8868\u793a\u300d\u3057\u305f\u3044\u3068\u304d\u306f “[h]:mm” \u3092\u4f7f\u7528\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

                \u5b9f\u969b\u306e\u8a2d\u5b9a\u4f8b<\/h4>\n

                \/\/ \u9031\u9593\u52e4\u52d9\u6642\u9593\u306e\u5408\u8a08<\/p>\n

                \u6708: 8:30<\/p>\n

                \u706b: 9:00<\/p>\n

                \u6c34: 8:45<\/p>\n

                \u6728: 7:30<\/p>\n

                \u91d1: 8:15<\/p>\n

                \u5408\u8a08: =SUM(\u4e0a\u8a18\u7bc4\u56f2)\u00a0 \/\/ 42:00\uff08[h]:mm\u5f62\u5f0f\u3067\u8868\u793a\uff09<\/p>\n

                \/\/ \u6708\u9593\u52e4\u52d9\u6642\u9593\uff08180\u6642\u9593\u8d85\uff09<\/p>\n

                =SUM(A1:A31)\u00a0 \/\/ 185:30:00\uff08[h]:mm:ss\u5f62\u5f0f\uff09<\/p>\n

                \u65e5\u6570\u3092\u542b\u3080\u6642\u9593\u8a08\u7b97\u3068\u8868\u793a\u65b9\u6cd5\u306f\uff1f<\/h3>\n

                \u65e5\u6570\u3092\u542b\u3080\u9577\u671f\u9593\u306e\u6642\u9593\u8a08\u7b97\u3067\u306f\u3001\u6642\u9593\u30b7\u30ea\u30a2\u30eb\u5024\u00d724\u3067\u7dcf\u6642\u9593\u6570\u3092\u6c42\u3081\u308b\u306e\u304c\u6b63\u78ba\u3067\u3059\uff08\u4f8b\uff1a=A1*24\u3001\u6574\u6570\u5316\u3059\u308b\u306a\u3089 =INT(A1*24)\uff09\u3002<\/b><\/span>\u3042\u308b\u3044\u306f\u65e5\u6570\u3068\u6642\u9593\u3092\u5206\u3051\u3066\u8868\u793a\u3057\u307e\u3059\u3002<\/p>\n

                \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u7ba1\u7406\u3084\u9577\u671f\u306e\u4f5c\u696d\u6642\u9593\u96c6\u8a08\u3067\u6d3b\u7528\u3067\u304d\u307e\u3059\u3002<\/p>\n

                \u65e5\u6570\u3068\u6642\u9593\u306e\u5206\u96e2\u8868\u793a<\/h4>\n

                A1: 250:30:00\u00a0 \uff08250\u6642\u959330\u5206\u306e\u7d2f\u8a08\uff09<\/p>\n

                \/\/ \u65e5\u6570\u3068\u6642\u9593\u306b\u5206\u89e3<\/p>\n

                B1: =INT(A1)&”\u65e5 “&TEXT(MOD(A1,1),”h:mm”)<\/p>\n

                \/\/ \u7d50\u679c\uff1a10\u65e5 10:30<\/p>\n

                \/\/ \u3088\u308a\u8a73\u7d30\u306a\u5206\u89e3<\/p>\n

                C1: =INT(A1)\u00a0 \/\/ 10\uff08\u65e5\uff09<\/p>\n

                D1: =HOUR(MOD(A1,1))\u00a0 \/\/ 10\uff08\u6642\u9593\uff09<\/p>\n

                E1: =MINUTE(A1)\u00a0 \/\/ 30\uff08\u5206\uff09<\/p>\n

                \/\/ \u30ab\u30b9\u30bf\u30e0\u8868\u793a<\/p>\n

                F1: =C1&”\u65e5”&D1&”\u6642\u9593”&E1&”\u5206”<\/p>\n

                \/\/ \u7d50\u679c\uff1a10\u65e510\u6642\u959330\u5206<\/p>\n

                \u55b6\u696d\u65e5\u63db\u7b97\u3067\u306e\u8868\u793a<\/h4>\n

                A1: 185:30:00\u00a0 \uff08\u7dcf\u4f5c\u696d\u6642\u9593\uff09<\/p>\n

                \/\/ 8\u6642\u9593\u30921\u55b6\u696d\u65e5\u3068\u3057\u3066\u63db\u7b97<\/p>\n

                B1: =INT(A1*24\/8)&”\u55b6\u696d\u65e5 “&TEXT(MOD(A1*24,8)\/24,”h:mm”)<\/p>\n

                \/\/ \u7d50\u679c\uff1a23\u55b6\u696d\u65e5 1:30<\/p>\n

                \/\/ \u9031\u3068\u65e5\u306b\u5206\u89e3\uff08\u90315\u65e5\u30011\u65e58\u6642\u9593\uff09<\/p>\n

                C1: =INT(A1*24\/40)&”\u9031 “&INT(MOD(A1*24,40)\/8)&”\u65e5 “&TEXT(MOD(A1*24,8)\/24,”h:mm”)<\/p>\n

                \/\/ \u7d50\u679c\uff1a4\u9031 3\u65e5 1:30<\/p>\n

                \u6642\u9593\u306e\u8db3\u3057\u7b97\u3092\u52b9\u7387\u5316\u3059\u308b\u5b9f\u8df5\u7684\u306a\u6d3b\u7528\u4f8b<\/h2>\n

                \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6642\u9593\u306e\u8db3\u3057\u7b97\u3092\u3059\u308b\u57fa\u672c\u304b\u3089\u5fdc\u7528\u307e\u3067\u3001\u69d8\u3005\u306a\u8a08\u7b97\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u3066\u304d\u307e\u3057\u305f\u3002\u5358\u7d14\u306a\u300c+\u300d\u6f14\u7b97\u5b50\u306b\u3088\u308b\u6642\u9593\u306e\u52a0\u7b97\u304b\u3089\u3001SUM\u95a2\u6570\u3067\u306e\u4e00\u62ec\u96c6\u8a08\u300124\u6642\u9593\u3092\u8d85\u3048\u308b\u8868\u793a\u5f62\u5f0f\u306e\u8a2d\u5b9a\u307e\u3067\u3001\u5b9f\u52d9\u3067\u5fc5\u8981\u306a\u30c6\u30af\u30cb\u30c3\u30af\u3092\u7db2\u7f85\u3057\u3066\u3044\u307e\u3059\u3002\u7279\u306b\u91cd\u8981\u306a\u306e\u306f\u300124\u6642\u9593\u3092\u8d85\u3048\u308b\u5834\u5408\u306e[h]:mm\u5f62\u5f0f\u306e\u8a2d\u5b9a\u3068\u3001TIME\u95a2\u6570\u3092\u4f7f\u3063\u305f\u67d4\u8edf\u306a\u6642\u9593\u64cd\u4f5c\u3067\u3059\u3002<\/p>\n

                \u52e4\u52d9\u6642\u9593\u7ba1\u7406\u306b\u304a\u3044\u3066\u306f\u3001\u51fa\u9000\u52e4\u6642\u523b\u304b\u3089\u306e\u5b9f\u50cd\u6642\u9593\u8a08\u7b97\u3001\u6b8b\u696d\u30fb\u6df1\u591c\u624b\u5f53\u306e\u81ea\u52d5\u8a08\u7b97\u306a\u3069\u3001\u8907\u96d1\u306a\u8981\u4ef6\u306b\u3082\u5bfe\u5fdc\u3067\u304d\u308b\u6570\u5f0f\u3092\u6d3b\u7528\u3059\u308b\u3053\u3068\u3067\u3001\u696d\u52d9\u52b9\u7387\u3092\u5927\u5e45\u306b\u5411\u4e0a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u307e\u305a\u306f\u57fa\u672c\u7684\u306a\u6642\u9593\u306e\u8db3\u3057\u7b97\u304b\u3089\u59cb\u3081\u3066\u3001\u5f90\u3005\u306b\u9ad8\u5ea6\u306a\u6a5f\u80fd\u3092\u53d6\u308a\u5165\u308c\u3066\u3044\u304f\u3053\u3068\u3067\u3001\u30df\u30b9\u306e\u306a\u3044\u6b63\u78ba\u306a\u6642\u9593\u8a08\u7b97\u30b7\u30b9\u30c6\u30e0\u3092\u69cb\u7bc9\u3067\u304d\u308b\u3067\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

                Google\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u52e4\u52d9\u6642\u9593\u306e\u96c6\u8a08\u3084\u4f5c\u696d\u6642\u9593\u306e\u5408\u8a08\u3092\u8a08\u7b97\u3059\u308b\u969b\u3001\u6642\u9593\u306e\u8db3\u3057\u7b97\u304c\u6b63\u3057\u304f\u3067\u304d\u305a\u306b\u56f0\u3063\u305f\u7d4c\u9a13\u306f\u3042\u308a\u307e\u305b\u3093\u304b\uff1f \u672c\u8a18\u4e8b\u3067\u306f\u3001\u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8\u3067\u6642\u9593\u3092\u8db3\u3057\u7b97\u3059\u308b\u57fa\u672c\u7684\u306a\u65b9\u6cd5\u304b\u3089\u300124\u6642\u9593\u3092\u8d85\u3048\u308b\u6642\u9593\u306e\u6b63\u3057 […]<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-20170","post","type-post","status-publish","format-standard","hentry","category-excel"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts\/20170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/comments?post=20170"}],"version-history":[{"count":12,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts\/20170\/revisions"}],"predecessor-version":[{"id":20589,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/posts\/20170\/revisions\/20589"}],"wp:attachment":[{"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/media?parent=20170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/categories?post=20170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/biz.moneyforward.com\/work-efficiency\/basic\/wp-json\/wp\/v2\/tags?post=20170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}