+40 Hours in a Week Overtime Fromula

C

Chelsea

I need help calculating a formula for when someone works over 8 hours a day
and over 40 regular hours in the first five days of the week. I would like
it to kick over the additional hours after 40 hours to overtime. Here's how
my spreadsheet is layed out:

Column C is Time IN
Column D is Time OUT
Column E is Time IN
Column F is Time OUT
Column G I have Total Hours using formula:
=((F5-C5+(F5<C5))-(E5-D5+(E5<D5)))*24
Column H I have Regular hours using formula: =MIN($G$1, G5)
Column I has Overtime Hours using formula: =MAX(0,G5-$G$1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top