Calculating a cost from hh:mm:ss

[mattandrew]

I use excel to manage phone bills I get from my supplier. The duration of the call is given as the following (hh:mm:ss) ie 00:10:52 I need to be able to work out the cost of this call with a formula. Say for example the call costs 10p per minute. Is there an easy formula to use

[sweep]

Hi,

You can use =(HOUR(A1)*60)+MINUTE(A1)+(SECOND(A1)/60) to resolve into minutes, but you'll have to format the cell to general number format.

HTH

Dave

[starguy]

I use excel to manage phone bills I get from my supplier. The duration of the call is given as the following (hh:mm:ss) ie 00:10:52 I need to be able to work out the cost of this call with a formula. Say for example the call costs 10p per minute. Is there an easy formula to use

to calculate total cost of call

=((HOUR(A1)*60)+MINUTE(A1)+(SECOND(A1)/60))*0.1
format should be general.

[Dav]

if the cell is formated hh:mm:ss

=0.1*a1*24

Regards

Dav