Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting hours
date, start time, finish time, total hours
1/2/2008 04:00 16:30 12.5 i need to break down the total hours figure into normal hours and time and half hours its time and half between 20:00 and 05:00 and also go onto time and half after 10 hours does anyone know how i could do this, thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
counting hours
In your example, of the 12.5 total hours, how many are regular and how many
time-and-a-half? Does the hour worked from 04:00 to 05:00 count towards the 10-hour regular time limit, or not? Also, can any of the shifts span midnight? Regards Fred "John" wrote in message ... date, start time, finish time, total hours 1/2/2008 04:00 16:30 12.5 i need to break down the total hours figure into normal hours and time and half hours its time and half between 20:00 and 05:00 and also go onto time and half after 10 hours does anyone know how i could do this, thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting number of hours per project per team | Excel Discussion (Misc queries) | |||
Counting DD:HH:MM NETWORKDAYS and Hours | Excel Worksheet Functions | |||
counting hours from cell with time-table. | New Users to Excel | |||
Date (hours and still counting) | Excel Worksheet Functions | |||
Counting Occurences of Hours of the Day | Excel Discussion (Misc queries) |