I am trying to set up a spread sheet to calculate a premium wage (extra $0.25) for employees who work Midnight to 6am.
I have to keep it simple on the inputting side of things and would like the format to be:
Start Time | Finish Time | Regular Hours | Premium Hours
This can be used to pull the time range data:
00:00:00 | 06:00:00
What I need is a function that will sum both regular and premium hours, and separate them in different cell's.
I have tried a couple IF statements, and just can't get it to work right. Any help would be appreciated.
Thanks
Bookmarks