G Guest Mar 27, 2006 #1 please could I have a formula or function to enter start time-end time and show total hours/mins for excel
please could I have a formula or function to enter start time-end time and show total hours/mins for excel
P Peo Sjoblom Mar 27, 2006 #2 =B1-A1 =B1-A1+(A1>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
=B1-A1 =B1-A1+(A1>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
