ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   +40 Hours in a Week Overtime Fromula (https://www.excelbanter.com/excel-worksheet-functions/101964-40-hours-week-overtime-fromula.html)

Chelsea

+40 Hours in a Week Overtime Fromula
 
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)


All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com