{"id":3176,"date":"2020-01-31T19:22:49","date_gmt":"2020-01-31T10:22:49","guid":{"rendered":"https:\/\/pasocollege.com\/book\/?page_id=3176"},"modified":"2024-12-02T14:37:20","modified_gmt":"2024-12-02T05:37:20","slug":"%e6%99%82%e9%96%93%e3%81%ae%e8%a8%88%e7%ae%97%e3%81%a8%e9%96%a2%e6%95%b0%e3%82%92%e6%a5%b5%e3%82%81%e3%82%8b%ef%bc%81-%e5%8b%a4%e6%80%a0%e7%ae%a1%e7%90%86%e7%a5%a8%e3%82%92%e4%bd%9c%e3%82%8d%e3%81%86","status":"publish","type":"page","link":"https:\/\/pasocollege.com\/book\/titles\/%e6%99%82%e9%96%93%e3%81%ae%e8%a8%88%e7%ae%97%e3%81%a8%e9%96%a2%e6%95%b0%e3%82%92%e6%a5%b5%e3%82%81%e3%82%8b%ef%bc%81-%e5%8b%a4%e6%80%a0%e7%ae%a1%e7%90%86%e7%a5%a8%e3%82%92%e4%bd%9c%e3%82%8d%e3%81%86\/","title":{"rendered":"\u6642\u9593\u306e\u8a08\u7b97\u3068\u95a2\u6570\u3092\u6975\u3081\u308b\uff01 \u52e4\u6020\u7ba1\u7406\u7968\u3092\u4f5c\u308d\u3046"},"content":{"rendered":"
\n
\"\"<\/figure>\n<\/div>\n\n\n

\u30c6\u30ad\u30b9\u30c8\u3067\u306f\u6642\u9593\u95a2\u6570\u306e\u4ed5\u7d44\u307f\u3092\u5b66\u3073\u306a\u304c\u3089\u3001\u3088\u308a\u5b9f\u7528\u7684\u306aExcel\u3067\u306e\u6642\u9593\u8a08\u7b97\u306e\u65b9\u6cd5\u3092\u8eab\u306b\u3064\u3051\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n\n\n\n

\u524d\u534a\u306f\u3001\u52e4\u6020\u7ba1\u7406\u7968\u3092\u4f5c\u308b\u3068\u304d\u306b\u5229\u7528\u3059\u308b\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u3092\u5b66\u3073\u307e\u3059\u3002
\u5f8c\u534a\u306f\u3001\u524d\u534a\u3067\u5b66\u3093\u3060\u95a2\u6570\u3084\u65b0\u3057\u3044\u95a2\u6570\u3092\u4f7f\u3044\u306a\u304c\u3089\u52e4\u6020\u7ba1\u7406\u7968\u3092\u4f5c\u308a\u3001\u6642\u9593\u8a08\u7b97\u306e\u3088\u308a\u5b9f\u8df5\u7684\u306a\u4f7f\u3044\u65b9\u3092\u5b66\u3073\u307e\u3059\u3002<\/p>\n\n\n\n

\u3054\u8cfc\u5165\u60c5\u5831<\/h3>\n\n\n\n
\u63a8\u5968\u5b66\u7fd2\u6642\u9593<\/td>4\u6642\u9593<\/td><\/tr>
\u30da\u30fc\u30b8\u6570<\/td>\u8a0873\u9801<\/td><\/tr>
\u5b66\u7fd2\u5bfe\u8c61\u8005<\/td>\u30a8\u30af\u30bb\u30eb\u9054\u4eba\u300c\u52e4\u52d9\u8868\u300d\u306e\u4fee\u4e86\u8005\u3001
\u95a2\u6570\u306e\u30cd\u30b9\u30c8\u304a\u3088\u3073\u4ee5\u4e0b\u306e\u95a2\u6570\u3092\u4f7f\u3048\u308b\u65b9
IF\u3001SUMIF\u3001COUNTIF\u3001INDIRECT\u95a2\u6570<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/p>\n\n\n\n

\u5185\u5bb9<\/h2>\n\n\n\n

\u76ee\u6b21\uff08\u4e00\u90e8\u629c\u7c8b\uff09<\/p>\n\n\n\n

1.\u65e5\u4ed8\u3068\u6642\u523b\u306e\u8868\u793a(TODAY,NOW)
2.\u65e5\u4ed8\u3084\u6642\u523b\u304b\u3089\u306e\u30c7\u30fc\u30bf\u306e\u53d6\u5f97(HOUR,MINUTE)
3.\u65e5\u4ed8\u3001\u6642\u523b\u30c7\u30fc\u30bf\u3078\u306e\u5909\u63db(DATE,TIME)
4.\u66dc\u65e5\u306e\u53d6\u5f97(WEEKDAY,\u8868\u793a\u5f62\u5f0f)
5.\u30bf\u30a4\u30e0\u30ab\u30fc\u30c9\u306e\u4f5c\u6210(IF,MONTH,IFERROR,TEXT,WEEKNUM)
6.\u52e4\u6020\u6642\u9593\u306e\u5165\u529b\u3068\u7aef\u6570\u51e6\u7406(CEILING.MATH,IF,FLOOR.MATH)
7. \u52e4\u52d9\u6642\u9593\u3068\u5b9f\u50cd\u6642\u9593(TIMEVALUE)
8. \u52b4\u50cd\u6642\u9593\u306e\u533a\u5206
9.\u52b4\u50cd\u6642\u9593\u306e\u307e\u3068\u3081
10.\u307e\u3068\u3081\u30b7\u30fc\u30c8\u306e\u4f5c\u6210
\u4ed8\u9332\uff1a\u30b7\u30ea\u30a2\u30eb\u5024\u3068\u65e5\u4ed8\u3068\u6642\u523b\u306e\u7ba1\u7406\u306b\u3064\u3044\u3066<\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

\u52e4\u6020\u7ba1\u7406\u7968\u3092\u4f5c\u6210\u3057\u306a\u304c\u3089\u3001TODAY\u30fbNOW\u30fbHOUR\u30fbMINUTE\u30fbDATE\u30fbTIME\u30fbWEEKNUM\u30fbTIMEVALUE\u95a2\u6570\u306a\u3069\u306e\u6642\u9593\u95a2\u6570\u306e\u4ed5\u7d44\u307f\u3092\u5b66\u3073\u3001\u3088\u308a\u5b9f\u7528\u7684\u306aExcel\u3067\u306e\u6642\u9593\u8a08\u7b97\u306e\u65b9\u6cd5\u3092\u8eab\u306b\u3064\u3051\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n","protected":false},"author":1,"featured_media":3177,"parent":1514,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"vkexunit_cta_each_option":"","footnotes":""},"categories":[26,99,94,89,49],"tags":[],"class_list":["post-3176","page","type-page","status-publish","has-post-thumbnail","hentry","category-excel","category-text","category-hr","category-planning","category-licentiate"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/3176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/comments?post=3176"}],"version-history":[{"count":8,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/3176\/revisions"}],"predecessor-version":[{"id":5047,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/3176\/revisions\/5047"}],"up":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/pages\/1514"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/media\/3177"}],"wp:attachment":[{"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/media?parent=3176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/categories?post=3176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pasocollege.com\/book\/wp-json\/wp\/v2\/tags?post=3176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}