Timesheet that calcs time in, time out, lunch used, reg hours, ot hours, double hours

Hello, I'm new to forums and excel so thanks in advance and take it easy on me =)

I have a timesheet for work that I want to calculate the regular hours, overtime hours, and even the option for double time hours. Regular hours would be 8, overtime anything over 8 and double time anything over 12. I also want the timesheet to take in account for lunch time used. There isn't a lunch time in/time out, just 1 for the hour used, but sometimes lunch is only .5 for 30 minutes. I've seem to figure out how to make sure regular hours don't exceed 8 and put the excess into the overtime cell. I can't figure out how to subtract the lunch from the regular hours worked and calculate double time.

Thanks in advance

=IF((F8+G8>12),F8+G8-12,0)

Hi

The above should calculate the double time for you. In respect of lunch amend your formulas to subtract the time entered in the lunch column.


Hope that helps


Chris

Hi

I will have another look for you will any of the work involve overnight into the following day. The ,"" comes at the end just before the closing bracket. You may find it easier and simpler to add an extra column for total hours worked and then work out your overtime rates from that total.

Chris

Hi

OK I have amended my post if you add the one extra column as suggested it would then be a simple case of any value over 12 goes in at double time, values between 8 and 12 normal overtime and 8 hours as standard

Chris

Hi noobface

Have a look at the attached, see if this is of any help.
1/ Reg Hours: up to 8hrs
2: O/T Hours: for over 8 hrs up to 12 hrs
3: D/T Hours: Anything over 12 hrs

Note: These are for times on the same day, if the go into the next day. Then you might need to use the MOD function or an IF function to account for that.

Hi noobface

Thanks for the feed back.

It is different then what dogberry was suggesting. There is no need for a extra column!

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread