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

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?

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 <atyahoo<dotcom
---
"Louis" wrote in message
...
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?