Blogtrottr
Mobile01最新文章
 
Own a Kindle?

We find the best deals on Kindle books for you. Just tell us which genres you love and we'll do the rest. The best part? It's completely free! Sign up today.
From our sponsors
【Excel工時】如何用excel計算工作隔天的時間? ((已解決))
Jul 1st 2014, 05:11

我是
6/30 17:46上班,
休息打卡下班是20:04,
休息打卡上班是20:32,
7/01 00:10下班

請問,Excel要怎麼計算這期間總共幾小時?
我在網路找到的公式:=SUM((C5-C4)*24,(C3-C2)*24)
可是這個公式算出來是-18小時

麻煩大家幫幫我怎麼算出有幾小時~~

註：很感謝大家對我的幫助，感恩不盡！！！！

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.
You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 xals2q 的頭像
    xals2q

    2015花千骨線上看tv 2016花千骨 花千骨線上看drama q 花千骨線上看drama 仙俠奇緣之花千骨線上看 花千骨線上看tv543 電視劇花千骨線上看 花千骨線上看第一集

    xals2q 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄