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