Dum IF statement question!

[jackmccarthy]

Hello
I have a calculated column in powerpivot that has numbers 0 thur 24 called "hour of day" That represent the hours of the day.
I need to say if the hour is 0 to 8 "GRAVE" 8 TO 16 "DAY" AND 16 TO 24 "SWING". Can someone please give me the =if statement for this?

This is what I have. Not working
=IF([hour of day]<8,"GRAVE",IF([hour of day]<16,"DAY","SWING"))THANKS </pre>

 

[jackmccarthy]

[hour of day] is [datetimestamp],"HH" The [datetimestamp] is 9/24/2012 12:50:58 pm Hope that is what your looking for.

 

[MD610]

Try using =HOUR([datetimestamp]) instead for [hour of day].

 

[Laurent C]

MD610 is right on point.

Explanation: formatting a date has no impact on its value. When compared to a numeric value, your date (9/24/2012 12:50:58 pm) will be casted to a numeric value as well (41176.53... in that case). For any recent dates this number will always be larger than 16.

 

[jackmccarthy]

that work perfectly Thanks!!!!!! please see other post from today. If anyone can help there I will by you all drinks!!!!