Using IF to capture overtime.

[arisigfusson]

So, I have been scratching my head for about two hours now.

I'm trying to figure out how to calculate overtime.
Overtime is after 5 pm each weekday and during the weekend.
Can somebody write up a formula for me that does this?

The Lunch column (D1) doesn't matter in this spreadsheet.


http://s12.postimg.org/o0wnqpdv1/Scr...t_18_32_53.png

[protonLeah]

Post the workbook directly to the forum:
To attach a Workbook
(please do not post pictures of worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[popipipo]

Try this:
=HOUR(C2-"17:00")

[arisigfusson]

Hey, thank you, but this won't suffice. As I said I'm trying to find out how to calculate the overtime hours from the total hours(overtime is every weekday after 17:00 and during the weekend(sat, sun)).
And also the regular hours from the total hours(each weekday before 17:00)

[ThirtyTwo]

try this is G2

Please Login or Register  to view this content.

and this in H2

Please Login or Register  to view this content.

copy and past down

let's see if it's doing the first part of you want, then we can move on to the next part

[newdoverman]

Does starting early count for overtime?

[arisigfusson]

Does starting early count for overtime?

Yes starting before 5 counts as overtime, sorry for not including that.

[newdoverman]

This might get you started.