Trying to use an IF function to return a value when a time is less than 01:00 in HH:SS

[jonboy0766]

Hi

I have a time displayed in HH:MM in a spreadsheet, I'm trying to use an IF function to return a YES or NO if the time is less than 01:00 i.e. 00:57, BTW I am using two ifs.

=IF(I3<E3,IF(L3<01:00)),"Yes","Fail"

Thnaks

Jon

[jeffreybrown]

Hi Jon & Welcome to the Forum,

Maybe try...

=IF(I3<E3,IF(L3<TIME(1,0,0),"Yes","Fail"))

[bebo021999]

Excel store 1 day = 24h = 1
1h=1/24
01:00 is time format= 1/24
Try to replace 01:00 in your function by 1/24.

[jonboy0766]

Thanks Jeff, that does the job. Why wouldn't my way work?

Cheers

Jon