Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for hours on time sheet
I have a time sheet that calculates start time and end time, neither of which
could be constant times. That formula works fine. I am looking to take the total hours for any given day and break them down into regular hours (upto and including 8 hrs) and overtime pay (anything over 8 hours). The problem is that some days there might not be a full 8 hrs put in and then the overtime hours result in an error. The way I have it set up now is for OT to subtract 8hrs from the Total hrs. and then the Regular time subtracts the OT hours (or minutes) from the Total time. How can I tell the OT formulat to do what I told it to but if the answer is a negative number to just enter '0'? Or is there an easier solution??? Can anyone assist me???? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
Time Sheet to show hours owed | Excel Worksheet Functions | |||
Is there a time sheet template that calculates hours? | Excel Discussion (Misc queries) | |||
Is there a time sheet template that calculates hours? | Excel Discussion (Misc queries) | |||
time-sheet record with over 24 hours | New Users to Excel |