template or formula for start time -finish time -total hours ple
=B1-A1
=B1-A1+(A1B1)
=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
"cc" wrote in message
...
please could I have a formula or function to enter start time-end time and
show total hours/mins for excel
|