Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up function is 1am between 8a-8p or between 8p-8a?
If you have a column of time 1:00, 1:02, 6:23, 15:24, etc....and you want a
formula to tell you if B2(1:02) is between 8:00 and 20:00 then it is day and if B2 is between 20:00 and 8:00 then it is night. This is what I have but it doesn't work....I'm off somewhere...it doesnt' always work correctly. =IF((B23B27:B23<B26), "day","night") In this case B27 is the 8am time and B26 is the 8pm time. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up function is 1am between 8a-8p or between 8p-8a?
=IF(AND(A1=$B$27,A1<=$B$26),"day","night")
HTH -- AP "Rita" a écrit dans le message de news: ... If you have a column of time 1:00, 1:02, 6:23, 15:24, etc....and you want a formula to tell you if B2(1:02) is between 8:00 and 20:00 then it is day and if B2 is between 20:00 and 8:00 then it is night. This is what I have but it doesn't work....I'm off somewhere...it doesnt' always work correctly. =IF((B23B27:B23<B26), "day","night") In this case B27 is the 8am time and B26 is the 8pm time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up a condtional function that.... | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |