Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Figuring Late night Hours
I have a timesheet that allows employees to enter their start and end times
in regular time format. The current formulas then add up the amount of time actually worked wich is also deleivered in regular time format. Employees get an extra amount of money for working late night hours, so I would like to figure their time separately. For example they worked a total of 4:45 at (4h 45m) at the regular wage and then 2:00 (2h 0m) at the higher rate time. In essence Excel will have to look at the start and end times and determine if they fall between the "late night hours" then add the two times separatley. Any ideas? Is this even possible? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Figuring out hours worked | Excel Discussion (Misc queries) | |||
calculating time for late hours | Excel Worksheet Functions | |||
Figuring Late Payment on Mortgage | Excel Worksheet Functions | |||
Figuring hours | Excel Worksheet Functions | |||
Figuring hours | Excel Worksheet Functions |