Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert number to time | Excel Discussion (Misc queries) | |||
convert number to time | Excel Worksheet Functions | |||
Convert a number to a time | Excel Discussion (Misc queries) | |||
convert number to time format? | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) |