| 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 | |||
Linear Mode
