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
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
Hi Jon & Welcome to the Forum,
Maybe try...
=IF(I3<E3,IF(L3<TIME(1,0,0),"Yes","Fail"))
HTH
Regards, Jeff
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.
Quang PT
Thanks Jeff, that does the job. Why wouldn't my way work?
Cheers
Jon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks