Previous Topic Next Topic

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
Related:

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

The system time is invalid
LeonardPromise -
Anonymous User -

5 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

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

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response