Anathi,

Somethng like

=IF(B2A2,"Late","On Time")

Where B2 has the actual arrival time, and A2 has the scheduled arrival time.
This will work if you enter times as AM and PM only, without dates.

HTH,
Bernie
MS Excel MVP



<Anathi Sonqishe wrote in message
...
Hi!

Please help me with the formula and how to converte numeric time into
words.

Example: employee knock in at 9:00 am and arrives at 8:45 am (and the
answer is ontime) or if s/he came in 9:23 am ( answer is late)



YY san. wrote:

Converting text format of time/date into Excel time/date for subtr
02-Feb-10

Hi,
I need some help on date. I have the date and time in text format.
13/01/2010 10:34 AM
13/01/2010 1:56 PM

I need a formula to convert them to excel date/time format so that I can
do
subtraction between these dates.

Thank you very much,
YY

Previous Posts In This Thread:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Command Prompt Here with VS.NET Environment
http://www.eggheadcafe.com/tutorials...here-with.aspx