Excel-compare time
Solved
Tehani_t
Posted messages
245
Status
Membre
-
benou -
benou -
Hello,
How do we compare times?
Example:
A1: 5:30
If A1 > 5:30 then "OK" else "False"
I tried typing the following IF(C6<"6:30","6:30"-C6,0), but it doesn't work!!!
Configuration: Windows 7 / Firefox 3.5.7
How do we compare times?
Example:
A1: 5:30
If A1 > 5:30 then "OK" else "False"
I tried typing the following IF(C6<"6:30","6:30"-C6,0), but it doesn't work!!!
Configuration: Windows 7 / Firefox 3.5.7
2 réponses
Hi,
several options,
=IF( A1>"5:30"*1,"OK","False")
or in your formula you enter 5.5 for 5:30 and the formula will be
=IF( A1>5.5/24,"OK","False")
or in a cell you enter 5:30 and format your cell as Standard which gives you 0.229166667
your formula becomes
=IF( A1>0.229166666666667,"OK","False")
--
A+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
several options,
=IF( A1>"5:30"*1,"OK","False")
or in your formula you enter 5.5 for 5:30 and the formula will be
=IF( A1>5.5/24,"OK","False")
or in a cell you enter 5:30 and format your cell as Standard which gives you 0.229166667
your formula becomes
=IF( A1>0.229166666666667,"OK","False")
--
A+
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
Just tried it and it works!!!!!! Thanks a lot!!!!