converting seconds into time ?

[Former Member]

Hi I am converting seconds into time and I used the following formula:

=FormatNumber(Floor([Elapsed Time]/3600) ;"0") + ":" +

FormatNumber(Floor(Mod([Elapsed Time];3600)/60);"00") + ":" +

FormatNumber(Mod(Mod([Elapsed Time] ;3600) ;60) ;"00")

The problem I now have is it is giving time as

0:02:50

1350:07:59

::

0:11:15

5:05:35

359:55:49

::

0:01:33

6:32:38

::

0:04:20

0:25:53

3:38:58

72:00:04

::

0:02:32

0:16:19

3:41:01

How do I convert something like second row above 1350:07:59 as days which is 56. 

Please help.

Thanks,

[Former Member · Accepted solution]

Hi,

Can you try this:

=FormatNumber((Floor([Elapsed Time]/3600)) / 24 ;"0") + ":" + FormatNumber(Mod(Floor([Elapsed Time]/3600),24) ;"0") + ":"

FormatNumber(Floor(Mod([Elapsed Time];3600)/60);"00") + ":" +

FormatNumber(Mod(Mod([Elapsed Time] ;3600) ;60) ;"00")

I have not tested it so it might have some syntax or logical errors.

Regards,

Yuvraj

[Former Member · Accepted solution]

Thanks Yuvraj, I have used the below the formula:

=FormatNumber((Floor([Elapsed Time]/3600))/24 ;"0") + ":" +

FormatNumber(Floor(Mod([Elapsed Time];3600)/60);"00") + ":" +

FormatNumber(Mod(Mod([Elapsed Time] ;3600) ;60) ;"00")

and I got the below results.  How do I now convert it to a number such as 00.00, so that I can use it for calculation

0:02:50

56:07:59

::

0:11:15

0:05:35

15:55:49

::

0:01:33

0:32:38

::

0:04:20

0:25:53

0:38:58

3:00:04

::

0:02:32

0:16:19

0:41:01

3:00:04