data validation failed on time field

[only_lonely]

i have a overtime sheet to calculate the time on regular / over time.

how to tweak the formula to allow cross date input?

currently when i input time which is 00:00, data validation prompted (i off data validation), then calc result is wrong with negative value.

i want to allow user to input from 09:00 to 01:30 (next day) then calc still working.

[only_lonely]

attached the file.

[samba_ravi]

try below formula in data validation
=AND($E12<=1,ISNUMBER($E12),OR($E12>=$D12,$E12<=TIME(1,30,0)))

[only_lonely]

try below formula in data validation
=AND($E12<=1,ISNUMBER($E12),OR($E12>=$D12,$E12<=TIME(1,30,0)))

Thanks. Data validation working now.
But the regulars and OT hours calculation is wrong.
Example
09:30 in time
00:30 out time
1hr break
Regular hours become -11.0
OT hours is 0
Regular hours should be 10
OT hours should be 15 - 1 - 10 = 4

[JeteMc]

See if the following does what you want:
1) For the regular hours (G12): =IF(AND(D12<>"",E12<>""),MIN(D$8,(E12+(D12>E12)-D12-F12/24)*24),"")
2) For the overtime hours (H12): =IF(AND(D12<>"",E12<>""),MAX(0,(E12+(D12>E12)-D12-F12/24-G12/24)*24),"")
Let us know if you have any questions.