| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate a value between 2 times
we pay a nightshift allowance between 18:00 and 6:00.
I have a timesheet with start and end times. Say the shift started at 15:00 and ended at 23:00, I need an answer of 5, or if the shift started at 04:30 and ended at 12:00 I need an answer of 1.5 thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate diff. between 2 times | Excel Worksheet Functions | |||
| How to calculate the difference between two different times. | Excel Worksheet Functions | |||
| How Do I Calculate Times | Excel Discussion (Misc queries) | |||
| Calculate with codes and times | Excel Worksheet Functions | |||
| how to calculate between times | Excel Discussion (Misc queries) | |||
Threaded Mode
