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
|