Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In my datasource I have a timefield in seconds. I would like to convert that to hours.
I know how to do it like: 1:30, but in this case I would like to see 1.5 hours. Any ideas?
Kind regards,
Henco
Try
= your_seconds_field / (60 * 60)
If this doesn't work, can you post an example of your data.
=Interval(Time(Time#(YourTimeField,'ss'),'hh:mm'))*24
or
Simply
=Interval(Time#(YourTimeField,'ss'))*24