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>

 

[powerpivotpro]

Is [hour of day] column a numeric data type or text? just swinging in the dark here. send me the workbook!

 

[jackmccarthy]

ok Rob I would love to email it to you. What's the address?

 

[powerpivotpro]

It's spelled out in my signature above to avoid spam bots

 

[jackmccarthy]

Any luck yet?

 

[powerpivotpro]

Hrm. I have not received the file yet. Can you try robert.c.collie? That's an email account on gmail.

 

[Laurent C]

Is [hour of day] a column, a calculated column or a measure?

 

[jackmccarthy]

Hour of day is a calculated column formatted of of datetime stamp column

 

[Laurent C]

OK. Can you give the definition of the calculated column? My guess is that you compare numbers with dates and that causes the issue.

 

[jackmccarthy]

Ok ,Yes I have a powerpivot table called "transactions" in that table there is a column called [datetimestamp] its info is the date and time of day. I then added a new column formatted it to just return the hour 00 thur 24 [hour of day] then added another column
where the if statement is.

 

[Laurent C]

Sorry if was not clear about that: I was interested in knowing what the formula for [hour of day] is.