In Excel, if I have a cell with value 5, how do I convert that to show :05 as in five seconds?

Answer 1

if your 5 is in A1 use this formula: =A1/86400
Then format the cell with a custom format of :ss

Answer 2

1. Right click on the cell -- you may select the full column or row if you want to set property for the full column or row.
2. Select "Format cell"
3. Select "Category" - which ever suits your requirement.
4. You can choose and select different settings. Like if you select Number in category - you can choose number of digits after decimal, or if you select Time as category - you can choose different time styles.

Answer 3

if you are not using it for a calculation you can show it as text by typing

':05

this will display :05

if you need it as a numeric value to do a calculation just call it up in the calculation as =right(A2,2) where the cell is A2 and the number of characters you want is 2.

for example

Cell A1 Time
Cell A2 ':05
Cell B1 Time doubled
Cell B2 =Right(A2,2)*2

Answer 4

Format/ cell and then choose the time format with seconds.

Answer 5

The fastest way to get there is using the keyboard "ctrl + 1" to get the format dialog box and click on time.

Answer 6

right click the cell and then format. in type write \:ss for showing seconds only. hopw this solves u'r prob.

Answer 7

right click to format cells at far left click number click time and select 0.000 for seconds and type in number you want.

Answer 8

right click - format cells...