I don't know if this is possible. I can only hope.

In my attached time sheet, time is entered as 12-hour time and converted to 24-hour time. Then time is totaled (as an example) in column F. If the employee is off or on vacation, they enter OFF or VAC in the first cell of the day. Now I cannot add a formula to sum up the time because of these instances. Is there a way to sum the time IF time is entered. Then if any of these codes (BG, CHI, MTP, NB, OFF, T/0, VAC) are entered in the first cell of the day, I would like it to return 0 in the total column. Another issue I have is, the times may be from 11:00 PM on one day to 7:00 AM the next day.

This may be a long shot, but is this at all possible? PLEASE HELP!



Thank you in advance for your help.
Karen

Attached Files

Template.xlsx (29.6 KB, 4 views)