Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can this adjusted GPA formual be accomplised? | Excel Discussion (Misc queries) | |||
Total TIme worked | Excel Worksheet Functions | |||
Formula to deduct unpaid breaks in time sheet | Excel Discussion (Misc queries) | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |