hour function with decimal places

[dominicanlauf]

Hello everybody,

is there a opportunitiy to get decimal places from the hour function?

For example:

Timestamp: 02.05.2019 05:58:12

hour(timestamp) = 5

Now I want to get 5,97

Is this possible?

Thanks,

Dominic

[tresB · Accepted solution]

Hour() won't give that. You can try like:

=Num(Frac(Timestamp)*24, '##.00')

[dominicanlauf]

Great, thanks!