View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rog[_4_] Rog[_4_] is offline
external usenet poster
 
Posts: 2
Default help with hours minutes and seconds

This may be a fairly simple one. I am trying to format a cell so that I
only have to type "124545" to get the result of 12:45:45
(hour:minute:second).

I have tried using "Custom" formatting with the given options in excel,
but have not found the right solution yet. So here I am. Any way to
format the cell so that the output will display as desired (12:45:45)???

Thanks,
CW