Convert time to number shown

[Guest]

I have some data that has been downloaded from telecoms re phone bill and I
want to do some analysis. The length of call is show in hh:mm:ss format and I
want to use the actual figure in calculations. eg 00:03:15 becomes 3,
(rounded to nearest integer)

Is there a way to do this? formatting as a number just gives the date
serial number and the value or text functions return 0.002256944 - still the
date serial number. Any help much appreciated.

Sheila D

 

[Roger Govier]

Hi Sheila

Excel stores time as fractions of a day.
Multiply your value * 24 to get to hours then * 60 to get to minutes
Format the cell as General or Number
With 00:03:15 in A1
=A1*24*60 gives 3.25

 

[Guest]

obvious when you know how! Thank you Roger

Sheila