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
|