Convert seconds in hours

[Anonymous]

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

[Colin-Albert]

Try

= your_seconds_field / (60 * 60)

If this doesn't work, can you post an example of your data.

[MK_QSL]

=Interval(Time(Time#(YourTimeField,'ss'),'hh:mm'))*24

or

Simply

=Interval(Time#(YourTimeField,'ss'))*24