Hello, I've tried googling this but I'm struggling to understand how to use the IF function to calculate hours worked without using military time and without adding "AM/PM" to every shift entry. To avoid confusion over am/pm hours on 12-hour time, I want a formula that says "(If TimeOut is less than TimeIn, then add 12 hours) - Time In = total hours worked. I want to do that for the morning shift, and the afternoon shift and then add them together for total hours worked.
The formula I'm trying to use right now is :=IF(C4<B4,C4+12,C4)-B4 but I'm doing something wrong because it's simply giving me 12 no matter what my clock in/clock out times are. Does this make sense?
Thanks, I appreciate any help you can offer!
Bookmarks