Time formula in a single cell

Closed
Report
-
 Trowa -
Hi,
Kindly tell me the formula for time to get in a single cell (for delay).

Eg: 12:16-12:20. If the time i key as 12:18 (inbetween 12:16-12:20) it should shown as delay or 1 else Ontime or 0.

Please help me.

Thanks
Rajesh

1 reply

Hi Rajesh,

If you put your starttime in A1, your endtime in B1 and your testtime in C1 use the following formula:

=IF(C1>=A1,IF(C1<=B1,"Delay","On time"),"On time")

Best regards,
Trowa
0