Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering numbers to get the time
I am trying to enter a number such as 15075, so that the result is 1:50.75
(that is 1 minute 52 seconds and 75 one hundredths of a second). Thanks in advance biegs!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering numbers to get the time
hi, you could try right clicking on the cell you want to display times/dates
(or highlight the entire area) and select "Format Cells". Under the "Number" tab, you can select time, date or 'special' where you can choose different options. hope this helps. Ted. "biegs" wrote: I am trying to enter a number such as 15075, so that the result is 1:50.75 (that is 1 minute 52 seconds and 75 one hundredths of a second). Thanks in advance biegs!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering numbers to get the time
Try using the TIME function.
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering numbers to get the time
Are you looking for a formula that will calculate the time in a
separate cell? If so, the following formula will do: =TIME(0, LEFT(A2,LEN(A2)-4),MID(RIGHT(A2,4),1,2))+RIGHT(A2,2)/8640000 Assumption: there will always be two digits for the seconds and hundreths of seconds. In other words, we have the format: mm:ss.00. Use this format in your destination cell. HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numbers to time | Excel Worksheet Functions | |||
Adding numbers to several cells at one time | Excel Worksheet Functions | |||
unmet challenge | Excel Worksheet Functions | |||
Entering numbers with variable decimal places. | Excel Worksheet Functions | |||
Entering More than 15 numbers | Excel Discussion (Misc queries) |