{"id":785,"date":"2019-04-03T20:02:15","date_gmt":"2019-04-03T12:02:15","guid":{"rendered":"https:\/\/www.fyndpro.com\/?p=785"},"modified":"2020-04-30T13:43:58","modified_gmt":"2020-04-30T05:43:58","slug":"sum_correct_hours","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/cn\/sum_correct_hours\/","title":{"rendered":"\u8a08\u51fa\u6b63\u78ba\u7684\u5c0f\u6642\u7e3d\u548c"},"content":{"rendered":"<blockquote><p>\u5982\u679c\u8981\u8a08\u51fa\u6642\u9593\u7e3d\u548c\uff0c\u53ea\u7528SUM\u7684\u8a71\uff0c\u4f60\u7684\u7b54\u6848\u90fd\u4e0d\u6703\u8d85\u904e24\u5c0f\u6642\u7684\u3002<\/p><\/blockquote>\n<p><iframe loading=\"lazy\" title=\"\u3010Excel\u6559\u5b78\u3011\u8a08\u51fa\u6b63\u78ba\u7684\u5c0f\u6642\u7e3d\u548c\uff0c\u89e3\u6c7a\u6642\u9593\u76f8\u52a0\u5f8cExcel\u5ffd\u7565\u5929\u6578\u7684\u554f\u984c\" width=\"500\" height=\"375\" src=\"https:\/\/www.youtube.com\/embed\/-y-6RLIMMcA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p><em>*\u8acb\u6253\u958b\u5b57\u5e55<\/em><\/p>\n<p>\u7e3d\u7684\u4f86\u8aaa\uff0c\u53ea\u9700\u5728Format Cells\u5167Custom\u4e2d\u7684Type\u8f38\u5165\u300c[h]:mm:ss;@\u300d\u4fbf\u53ef\u3002<br \/>\n<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E8%A8%88%E5%87%BA%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%B0%8F%E6%99%82%E7%B8%BD%E5%92%8C.png?resize=577%2C552&#038;ssl=1\" alt=\"\" width=\"577\" height=\"552\" class=\"alignnone size-full wp-image-787\" srcset=\"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E8%A8%88%E5%87%BA%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%B0%8F%E6%99%82%E7%B8%BD%E5%92%8C.png?w=577&amp;ssl=1 577w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E8%A8%88%E5%87%BA%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%B0%8F%E6%99%82%E7%B8%BD%E5%92%8C.png?resize=150%2C144&amp;ssl=1 150w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E8%A8%88%E5%87%BA%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%B0%8F%E6%99%82%E7%B8%BD%E5%92%8C.png?resize=300%2C287&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E8%A8%88%E5%87%BA%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%B0%8F%E6%99%82%E7%B8%BD%E5%92%8C.png?resize=230%2C220&amp;ssl=1 230w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E8%A8%88%E5%87%BA%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%B0%8F%E6%99%82%E7%B8%BD%E5%92%8C.png?resize=350%2C335&amp;ssl=1 350w, https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E8%A8%88%E5%87%BA%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%B0%8F%E6%99%82%E7%B8%BD%E5%92%8C.png?resize=480%2C459&amp;ssl=1 480w\" sizes=\"auto, (max-width: 577px) 100vw, 577px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5982\u679c\u8981\u8a08\u51fa\u6642\u9593\u7e3d\u548c\uff0c\u53ea\u7528SUM\u7684\u8a71\uff0c\u4f60\u7684\u7b54\u6848\u90fd\u4e0d\u6703\u8d85\u904e24\u5c0f\u6642\u7684\u3002 &nbsp; *\u8acb\u6253\u958b\u5b57\u5e55 \u7e3d\u7684\u4f86\u8aaa\uff0c\u53ea\u9700 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1204,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[49,8,29,12,20,9],"tags":[13,52],"class_list":["post-785","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-date","category-excel","category-format","category-mathematical","category-onlinesupport","category-technique","tag-sum","tag-time"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2019\/04\/%E8%A8%88%E5%87%BA%E6%AD%A3%E7%A2%BA%E7%9A%84%E5%B0%8F%E6%99%82%E7%B8%BD%E5%92%8C4.png?fit=1084%2C681&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/comments?post=785"}],"version-history":[{"count":5,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/785\/revisions"}],"predecessor-version":[{"id":1212,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/posts\/785\/revisions\/1212"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media\/1204"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/media?parent=785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/categories?post=785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/cn\/wp-json\/wp\/v2\/tags?post=785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}