Formula shows ####### instead of 00:00 in cell

[Spicegold]

The formula works perfectly, except when I insert formula in H13 it shows ####### instead of 00:00 in H13 Actual overtime

=IF(F13<=TIME(10,0,0), IF(C13>F13-TIME(8,48,0)>=TIME(1,0,0),C13-TIME(8,48,0),0), IF(C13>F13-TIME(8,48,0)>=TIME(1,0,0),F13-TIME(8,48,0),0))

Dates and times that are negative or too large show as #######

This is where my problem is.

Only after I enter times from C13 to E13, it shows time in H13

So, when I insert the formula in column H downwards for each day of the month, it shows #######.

There are days when I’m not working, it show ####### and not 00:00

At the bottom in Total =SUM(H13:H44) it shows ####### and no time for the days I worked

New Formula.xlsx
	C	D	E	F	G	H
12	Shift length	Start time	End time	Total time	Over time	Actual overtime
13	10:00	06:00	14:48	08:48	00:00	01:12
14	10:00	06:00	17:00	11:00	02:12	02:12
15	12:00	06:00	18:00	12:00	03:12	03:12
16						###############
17	12:00	06:00	14:45			03:12
18						#################
Sheet2

Cell Formulas
Range	Formula
F13:F15	F13	=E13-D13
G13:G15	G13	=F13-TIME(8,48,0)
H13:H18	H13	=IF(F13<=TIME(10,0,0), IF(C13>F13-TIME(8,48,0)>=TIME(1,0,0),C13-TIME(8,48,0),0), IF(C13>F13-TIME(8,48,0)>=TIME(1,0,0),F13-TIME(8,48,0),0))

 

[Phuoc]

Try this in H13:

=Max(0, IF(F13<=TIME(10,0,0), IF(C13>F13-TIME(8,48,0)>=TIME(1,0,0),C13-TIME(8,48,0),0), IF(C13>F13-TIME(8,48,0)>=TIME(1,0,0),F13-TIME(8,48,0),0)))

 

[Spicegold]

Try this in H13:

=Max(0, IF(F13<=TIME(10,0,0), IF(C13>F13-TIME(8,48,0)>=TIME(1,0,0),C13-TIME(8,48,0),0), IF(C13>F13-TIME(8,48,0)>=TIME(1,0,0),F13-TIME(8,48,0),0)))

Thanks

Formula is working