DateTimestamp to Hour Only

[Anonymous]

Hi I have a DateTimeStamp (14/01/17  21:45)

I want to convert it to show Hour only (21) as a decimal.

Can anyone help?

Many thanks

[marcus_sommer · Accepted solution]

You could just use: hour(DateTimeStamp) for it.

- Marcus

[Anonymous]

How funny !!

You can't imagine how many combinations of rounding combined with calculations.

Muppet moment for me.

Thanks Mark

[Anonymous]

Marcus (not Mark)

[sunny_talwar]

You want to see it in decimal?

Ceil(Frac(DateTimeStamp), 1/24)