It gives me all NO's
This is my sheet
the cell it is calculating is a formula (B2-A2) and in a custom [h]:mm format

start date complete date hrs to complete
complete within 24hr
7/1/2009 8:30 AM 7/1/2009 9:30 AM 1:00 (=B2-A2) NO
7/1/2009 8:30 AM 7/2/2009 10:30 AM 26:00 NO

"Jacob Skaria" wrote:

=IF(C3TIME(24,0,0),"NO","YES")

If this post helps click Yes
---------------
Jacob Skaria


"Joshua" wrote:

I have two columns
Time taken to complete work Completed within 24hrs

23:00 Yes
25:00 No

I want to know if anything has gone over a 24hr time limit
before I had it calculate =IF(C324,"NO","YES")
so if C3 was 25:00 it would give me a NO or 23:00 a YES
right now it gives me all YES even if it is over 24
Do I have to change the format of =IF cell or input a new formula

Thanks for your time