Time formula in a single cell

Closed

Rajesh - May 31, 2010 at 08:11 AM
Trowa - May 31, 2010 at 08:48 AM

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

Time formula in a single cell
Popcorn time download - Download - Movies, series and TV
How to change time in whatsapp - Guide
Ocarina of time rom - Download - Action and adventure
Number to words in excel formula - Guide
Date formula in excel dd/mm/yyyy - Guide

1 response

Answer 1 / 1

Trowa
May 31, 2010 at 08:48 AM

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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel

The system time is invalid

How to calculate position (1st,2nd,3rd) in excel....?

Similar discussions

Subscribe To Our Newsletter!