Entering numbers to get the time

[biegs]

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!!!

 

[Guest]

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.

 

[Randall.Senn]

Try using the TIME function.

 

[vezerid]

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