Calculating Overtime in Excel: Daily vs Weekly and more

[@michaelnuguid5747]

Hey @Kenbraverman, I work for a company that I created a labor estimate template. I am jammed up at calculating the ST and OT pay. We pay employees overtime before 0800 and after 1700, as well as weekends and holidays. Seems similar to the large formula you described buried in your sheet. Can you help sort this out? I have an area where you enter in/out times as well as lunches. It shoots out a total hour worked, minus lunches. I am jammed up at it self populating ST and OT based on the day I selected from the calendar add-in.

[@KenBraverman]

Sounds like you need some extra columns to break out the time prior to 8am and and after 5pm from the Time in / Time Out logged so you can parse out the Overtime related to those hours. It gets more complex depending on the state you are because Overtime and Double Time can have different elements to it (California is an example of a unique state). I can help but I do in a contracting hourly rate capacity if you are interested. Contact me on KenBraverman.com

[@shaylasheen5917]

Hi - This is the one I have emailed you for, can I please purchase

[@KenBraverman]

Hi, I don't see the email try emailing [e-mail]

[@axelotero2414]

Can i get the Excel o Google Sheets?

[@KenBraverman]

Yes I have a version in both formats