Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting number to time
I have a column of numbers, ranging from 0 to 4000 seconds; A1 is 0, A2 is 1,
A3 is 2, etc. How do I convert that column to represent time, where 0 seconds is 00:00:00, 1 second is 00:00:01, 2 seconds is 00:00:02, and 60 seconds is 00:01:00, etc.? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting number to time
In B1:
=TIME(0,0,A1) fill down. Or the brutal way if you can't spare the B column: Enter 86400 in an empty cell (=the amount of seconds in a day, if you include the night). Copy that cell. Select your A cells. Go menu Edit Paste special, check Divide, OK. Format the cells as time. HTH. Best wishes Harald "bourbon84" skrev i melding ... I have a column of numbers, ranging from 0 to 4000 seconds; A1 is 0, A2 is 1, A3 is 2, etc. How do I convert that column to represent time, where 0 seconds is 00:00:00, 1 second is 00:00:01, 2 seconds is 00:00:02, and 60 seconds is 00:01:00, etc.? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting number to time
Format the column as TIME (00:00:00)
Do: Select Column header and right click, format cells,time, 00:00:00 Then in the time cells simply type =A# Where # is your data range Works in some of my spreadsheets "bourbon84" wrote: I have a column of numbers, ranging from 0 to 4000 seconds; A1 is 0, A2 is 1, A3 is 2, etc. How do I convert that column to represent time, where 0 seconds is 00:00:00, 1 second is 00:00:01, 2 seconds is 00:00:02, and 60 seconds is 00:01:00, etc.? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting number to time
Sorry, on checking my sheets I see a constant of 86400
correction, Type =A#/86400 "bourbon84" wrote: I have a column of numbers, ranging from 0 to 4000 seconds; A1 is 0, A2 is 1, A3 is 2, etc. How do I convert that column to represent time, where 0 seconds is 00:00:00, 1 second is 00:00:01, 2 seconds is 00:00:02, and 60 seconds is 00:01:00, etc.? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Eastern time to Central time | Excel Discussion (Misc queries) | |||
Selecting the first time a number appears | Excel Discussion (Misc queries) | |||
Selecting the first time a number appears (part 2) | Excel Discussion (Misc queries) | |||
Entering a number on any sheet one time only | Excel Discussion (Misc queries) | |||
Time format to number while keeping value | Excel Worksheet Functions |