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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks