How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min o.

[Guest]

How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min or 99 seconds
in order to multiply the duration with an amount or rate to give me a cost?

 

[Max]

With the time in A1, try

In B1: =A1*24*60
In C1: =A1*24*60*60

Format B1 and C1 as General

B1 returns 1.65 mins
C1 returns 99 sec
--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
---

How do I convert a time eg. 00:01:39 to a duration eg. 1.65 min or 99 seconds
in order to multiply the duration with an amount or rate to give me a

cost?