View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default When I input "25:03" as a time, it reads "1:03"

Format the cell as mm:ss

Then, when you enter the time you need to enter it as 0:25:03 but it will
display as 25:03.

--
Biff
Microsoft Excel MVP


"Darryl_Neeley" wrote in message
...
I need to know how to fix this little problem. I'm using the time as an
accumulated time, not as in a definitive time. As in 25 minutes, 3
seconds.

Thanks for the help. I'm sure it's probably a simple fix.