template or formula for start time -finish time -total hours ple
 

please could I have a formula or function to enter start time-end time and
show total hours/mins for excel

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