close
please could I have a formula or function to enter start time-end time and
show total hours/mins for excel
=B1-A1
=B1-A1 (A1gt;B1)
=MOD(B1-A1,1)with start time in A1 and end in B1 using excel time format hh:mm:ss
the first 2 formulas work if start is before and end is after midnight--
Regards,
Peo Sjoblom
quot;ccquot; gt; wrote in message
...
gt; please could I have a formula or function to enter start time-end time and
gt; show total hours/mins for excel
全站熱搜
留言列表
