View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ted
 
Posts: n/a
Default 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!!!