"incompelte entry" as a result in excel time sheet

[gerard_gonzales33]

My excel time sheet is almost done, Thanks everyone for the help and assistance to make this possible. Now am wondering if excel can give a result in phrase such as "incomplete entry" for M17 and N10 (it appears as 17:30)?

Also I would like to ask regarding the computation of overtime (12:00 PM - 1:00 00 is not paid) with consideration of start time on over time (H13).

H13 - consideration start time is 6:00 PM



Please see my sample time sheet.

Thank you so much.

[bebo021999]

If results displayed in R column.
In R9:

Please Login or Register  to view this content.

Counting overtime:
H13 = G13-F13
Format cell as: [hh]:00

[gerard_gonzales33]

Thanks bebo021999. But I have clarifications.
first: can the formula/code that you have shared with me be entered at M9 and N9 instead entering at R9 ( does in excel accepts two formulas in one cell?) in order that the computation for the tardy and under time will still compute?
and lastly: in counting the overtime how can I include the consideration of the unpaid break i.e. 12:00 PM to 1:00 PM and the start time of 6:00 PM (every Mondays to Fridays)?

Thanks in advance.