Time Issue

[mole999]

I have what should be a simple problem. I want to hide a time value if it is greater than the returned value (more than 12:00)

E should be the end time, X is the start time, either of which when empty is hidden

For an unknown data entry reason, some E are returning more than 12 hours from =IF(X2="","",IF(E2="","",IF(E2>X2, E2-X2, 1-X2+E2)))

when E contains 15:00 (end) and X contains 18:30 (start) the sum is 3.5 hours too early and shows as 20:30. so I want to hide the result of E2>X2, E2-X2, 1-X2+E2 when it is more than 12 hours. checked and it ISNUMBER(TRUE)

what have I missed

 

[Marcelo Branco]

Not sure i understand what you need. Maybe...

Pasta1
	A	B	C
1	Start	End	Result
2	15:00	18:30	03:30
3	18:30	15:00
4	15:00
5		18:00
6	07:00	19:30
7	07:00	19:00	12:00
8	22:00	01:20	03:20
Plan7

Cell Formulas
Range	Formula
C2:C8	C2	=IF(OR(A2="",B2=""),"",IF(MOD(B2-A2,1)>TIME(12,0,0),"",MOD(B2-A2,1)))

M.

 

[mole999]

That dose exactly what i wanted, had looked at MOD but not that way, thank you

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.