| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOURS CALCULATION
Would like to calculate no of hours in a specied shift. I can do this until
foe example start time is 22:00 and end time is 04:00 next day - Can somebody help ? -- Stuart |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOURS CALCULATION
If A1 is start time and B1 is end time:
=MOD(B1-A1,1) (make sure the result in time format.) Stuart Carnachan wrote: Would like to calculate no of hours in a specied shift. I can do this until foe example start time is 22:00 and end time is 04:00 next day - Can somebody help ? -- Stuart |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOURS CALCULATION
Fantastic
-- Stuart "Lori" wrote: If A1 is start time and B1 is end time: =MOD(B1-A1,1) (make sure the result in time format.) Stuart Carnachan wrote: Would like to calculate no of hours in a specied shift. I can do this until foe example start time is 22:00 and end time is 04:00 next day - Can somebody help ? -- Stuart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date and Time Response- before/during/after Business hours | Excel Discussion (Misc queries) | |||
| Working days and hours calculation - request assistance please! | Excel Worksheet Functions | |||
| Removing non Work Hours from Excel calculation | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Calculation of full hours | Excel Worksheet Functions | |||
Linear Mode
