Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hour() won't give that. You can try like:
=Num(Frac(Timestamp)*24, '##.00')
Hour() won't give that. You can try like:
=Num(Frac(Timestamp)*24, '##.00')
Great, thanks!