Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula?
I have a column of numbers that I need to convert to hh:mm:ss ie 57 changed
to 00:00:57. I have 1567 entries and was hoping there was a way of doing it rather than manually changing every entry!! Pls help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula?
Either copy 86400 and paste special divide and you may want to select values
to remove the formula. or you can enter the following formula in column b if the cells are in a =a1/86400 or you can use =time(0,0,a1). you then have to set the format to time with seconds to display properly. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "sarajayne" wrote: I have a column of numbers that I need to convert to hh:mm:ss ie 57 changed to 00:00:57. I have 1567 entries and was hoping there was a way of doing it rather than manually changing every entry!! Pls help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula?
Martin - you are a STAR!! Many thanx. Have never used this system before
but I will in the future. You've saved me many hours of laborious keying... Thanx again... "Martin Fishlock" wrote: Either copy 86400 and paste special divide and you may want to select values to remove the formula. or you can enter the following formula in column b if the cells are in a =a1/86400 or you can use =time(0,0,a1). you then have to set the format to time with seconds to display properly. -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "sarajayne" wrote: I have a column of numbers that I need to convert to hh:mm:ss ie 57 changed to 00:00:57. I have 1567 entries and was hoping there was a way of doing it rather than manually changing every entry!! Pls help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |