Convert time to number shown
 

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

Convert time to number shown
 

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
--
Regards

Roger Govier


"Sheila D" wrote in message
...
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

Convert time to number shown
 

obvious when you know how! Thank you Roger

Sheila

"Roger Govier" wrote:

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
--
Regards

Roger Govier


"Sheila D" wrote in message
...
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