Hi! Bernie
Im so pleased with help, I also tried to some other tricks
=IF(B3>=E3,"ontime", IF(B3<=E3,"late"))
although if E3 is 0:00 and B3 is 0:00 instead of showing 0:00 it says ontime.
Regards
Anathi
Bernie Deitrick wrote:
Anathi,Somethng like=IF(B2>A2,"Late","On Time")Where B2 has the actual arrival
04-Feb-10
Anathi
Somethng lik
=IF(B2>A2,"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
Berni
MS Excel MV
<Anathi Sonqishe> wrote in message
Previous Posts In This Thread:
Converting text format of time/date into Excel time/date for subtr
Hi
I need some help on date. I have the date and time in text format
13/01/2010 10:34 A
13/01/2010 1:56 P
I need a formula to convert them to excel date/time format so that I can d
subtraction between these dates
Thank you very much
YY
=DATEVALUE(LEFT(A1,FIND(" ",A1)-1))+TIMEVALUE(MID(A1,FIND("
=DATEVALUE(LEFT(A1,FIND(" ",A1)-1))+TIMEVALUE(MID(A1,FIND(" ",A1)+1,256)
-
Gary''s Student - gsnu20100
:
YY,You could try and just use=A3-A2or, to be clearer in your
YY
You could try and just us
=A3-A
or, to be clearer in your formula
=VALUE(A3)-VALUE(A2
HTH
Berni
MS Excel MVP
time to words
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)
Anathi,Somethng like=IF(B2>A2,"Late","On Time")Where B2 has the actual arrival
Anathi
Somethng lik
=IF(B2>A2,"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
Berni
MS Excel MV
<Anathi Sonqishe> wrote in message
Submitted via EggHeadCafe - Software Developer Portal of Choice
EggHeadCafe Chat Chaos in Silverlight Released Today
http://www.eggheadcafe.com/tutorial...6-54f31bdede5d/eggheadcafe-chat-chaos-in.aspx