Date & Time Syntax

[k602570]

Hi,

I m have a dataset that includes a time column, it loads to PP as a date. 12/30/1899 12:00:00 AM as an example. Based on the values, I'd like to put the time into "buckets": such as: Midnight to 6AM, 6AM to 10AM etc. I have tried to create a calculated column - If(and([Time] > 12/30/1899 11:59:59 PM, [Time]<= 12/30/1899 06:00:00 AM, "Midnight to 6AM", ""), but it's telling me the syntax for 11 in incorrect. I have tried multiple variations, any ideas?
Thanks in advance as all/any help is appreciated.

Kathy

 

[Tianbas]

try if(hour([Time])<6,"...

 

[k602570]

Perfection - worked like a charm! Thanks

 

[butlerrbrian]

I have encountered this by creating interval columns. Could be 10, 15, 30, any you'd need.

Interval:= IF(MINUTE([Time] >=30, HOUR([Time] + 0.5, HOUR[Time])

There are other variants, of course.