{"id":13722,"date":"2024-10-21T07:02:14","date_gmt":"2024-10-21T07:02:14","guid":{"rendered":"https:\/\/www.nicekj.com\/ask\/13722.html"},"modified":"2024-10-21T07:02:14","modified_gmt":"2024-10-21T07:02:14","slug":"tiancaimenzhege-excel-wentiwomengbile","status":"publish","type":"ask","link":"https:\/\/www.nicekj.com\/ask\/13722.html","title":{"rendered":"\u5929\u624d\u4eec\u8fd9\u4e2a EXCEL \u95ee\u9898\u6211\u61f5\u903c\u4e86\uff0c"},"content":{"rendered":"<p>A1 = 20:00:00<br \/>\nA2 = IF(A1&gt;=TIME(19,0,0), INT((A1-TIME(19,0,0))*24\/0.5)\/2, 0) <\/p>\n<p>\u6309\u7167\u516c\u5f0f\u8ba1\u7b97\uff0c\u5148\u5224\u65ad A1 \u662f\u5426\u5927\u4e8e 19:00:00 \uff0c\u5927\u4e8e\u4e0b\u4e00\u6b65\uff0c\u5426\u5219\u8fd4\u56de 0<br \/>\nINT((A1-TIME(19,0,0))*24\/0.5)\/2<br \/>\nINT((20:00:00-TIME(19,0,0))*24\/0.5)\/2<br \/>\nINT((1))*24\/0.5)\/2<br \/>\nINT(24\/0.5)\/2<br \/>\nINT(48)\/2<br \/>\nINT(24)<br \/>\n\u5367\u69fd\uff0c\u6700\u540e\u662f 24 \uff0c <\/p>\n<p>\u4f46\u662f\u6211\u5728 excel \u4e2d \u663e\u793a\u662f 20:00:00 1,\u662f 1 \uff0c\u8fd9\u662f\u6b63\u786e\u7684\u503c 1 <\/p>\n<p>\u6211\u60f3\u8ba1\u7b97\u4ee5 19:00:00 \u4e3a\u57fa\u6570\uff0c\u6bcf 30 \u5206\u949f\u4e3a 0.5 \u5c0f\u65f6\uff0c\u8ba1\u7b97\u52a0\u73ed\u65f6\u95f4\u30021 \u662f\u5bf9\u7684\uff0c <\/p>\n<p>\u4f46\u662f\u516c\u5f0f\u8ba1\u7b97\u7684 24 \uff0c\u8fd9\u4e2a\u53c8\u662f 1 \uff0c\u6211\u771f\u7684\u65e0\u8bed\uff0c\u5927\u4f6c\u4eec\u8fd9\u5565\u610f\u601d\uff0c\uff0c<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A1 = 20:00:00 A2 = IF(A1&gt;=TIME(19,0,0), INT((A1-TIME(19,0,0))*24\/0.5)\/2, 0) \u6309\u7167\u516c\u5f0f\u8ba1\u7b97\uff0c\u5148\u5224\u65ad A1 \u662f\u5426\u5927\u4e8e 19:00:00 \uff0c\u5927\u4e8e\u4e0b\u4e00\u6b65\uff0c\u5426\u5219\u8fd4\u56de 0 INT((A1-TIME(19,0,0))*24\/0.5)\/2 INT((20:00:00-TIME(19,0,0))*24\/0.5)\/2 INT((1))*24\/0.5)\/2 INT(24\/0.5)\/2 INT(48)\/2 INT(24) \u5367\u69fd\uff0c\u6700\u540e\u662f 24 \uff0c \u4f46\u662f\u6211\u5728 e<\/p>\n","protected":false},"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","ask_cat":[],"class_list":["post-13722","ask","type-ask","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/ask\/13722","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/ask"}],"about":[{"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/types\/ask"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/comments?post=13722"}],"wp:attachment":[{"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/media?parent=13722"}],"wp:term":[{"taxonomy":"ask_cat","embeddable":true,"href":"https:\/\/www.nicekj.com\/nicekj2024\/wp\/v2\/ask_cat?post=13722"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}