How to convert 680.1016158 to 11:20 ?

[marieclaire]

Hi the community,

I would like to analyse the time spent on web sites, regarding the trafic sources.

The format of the values are seconds : 680.1016158828.

I do not manage to convert it in 'mm:ss'.

I tried

=time((680.1016158828)/60,'mm:ss')

= interval#(680.1016158828, 'mm:ss' )

But i always get a wrong answer : 02:26:20.

I must obtain : 11:20

FYI, the settings are :

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

Does anybody know which function or expression i have to use ?

Thank you for your help.

Marie-Claire

[marcus_sommer]

Try:

time(1/24/60/60 * 680.1016158828,'mm:ss')

- Marcus

[marieclaire]

It works perfectly 

Thank you Marcus for this useful answer.

Marie-Claire