Calculating overtime in Excel for over 40 hrs per week

**mike4000** · 08-28-2013, 06:43 PM

Hi,
I`m trying to calculate overtime when I have more than 40 hours per week.
I have an spreadsheet where I enter the data like start time, end time and brake as result I have for example 57:00 Hours per week and need to calculate 40 hours per regular rate and the hours over 40 by 1.5.
But seems like I'm doing it wrong.

Please help!

Thanks for your time.

Mike

**Richard Buttrey** · 08-28-2013, 07:04 PM

Hi,

See attached.

Your workbook was confusing time 'numbers' which represent the differences in the numbers of days or fractions of days, and the numbers of hours which you need for your calculation.

**mike4000** · 11-13-2013, 11:46 AM

Thanks a lot for your help and sorry for my late reply. It works fine.

**arlu1201** · 11-14-2013, 06:16 AM

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time as you will not be able to do it.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.