Time and IF statement problems

[buyshirts]

What i am trying to achieve is determine whether it is Morning, Afternoon or Evening

In C3 i have a date and a time (with General format) in L3 i have the following formula to strip out the time only (=RIGHT(C3,7))



Thanks in advance for any help!

[buyshirts]

In F3 i have the follwoing formula =IF(L3<TIM*(14,0,0),"Morning",IF(L3>=TIME(18,0,0),"Evening","Afternoon")) for some reason all im getting is Eve.

[Olly]

One option:

Please Login or Register  to view this content.

[buyshirts]

Thanks very much!

so i didn't need to spilt the time out into L3?

[davsth]

or you get the time by =RIGHT(C3,7) becoming mod(C3,1)

then

=LOOKUP(l3,{0,14,18},{"Morning","Afternoon","Evening"})

[davsth]

No you could get it from the datetime function, although if you needed to the mod function retains it as a time, rather than text

[buyshirts]

Thanks very much

[Olly]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You may also 'Add Reputation' to those who helped you. Thanks.