Log In
Register
Home
June 22, 2020
Offline
Hello,
I need help with an issue that I can't get with the IF formula.
If the clock(time) is between 00:00 and 06:00h to return 1.
ie:if it's 01:00am to return 1. If not, return 0.
How can I get this solution?
Thank you.
Regards,
Riste.
See Answer
October 5, 2010
Offline
Hi Riste,
Times and dates are stored as 'serial' numbers in excel so if your time is in A1 you can use
=IF(AND(A1>0,A1<0.25),1,0)
This article explains Date and Time in Excel
Regards
Phil
Answers Post
June 22, 2020
Offline
Thank you Phil.
I appreciate it.
Best Regards,
Riste.
June 25, 2020
Offline
Hi Riste,
If your cell might also have a date component and you only wish to check that the time part is before 6am then you could use:
=--(ISNUMBER(A1)*(MOD(N(A1),1)<=0.25))
blanks, text and any times after 6am will return 0; times between midnight and 6am (inclusive) will return 1
Regards
jim
1 Guest(s)
