IF formula for time
Hi,
Change your formula to read
=IF(C31,"NO","YES")
To understand why chage the format of C3 to number, many decimals.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Joshua" wrote:
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
|