help with hours minutes and seconds

[Rog]

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

[Niek Otten]

http://www.cpearson.com/excel/DateTimeEntry.htm

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Rog" <clint.wagner@gmail.com> wrote in message
news:eiPSC$KBFHA.936@TK2MSFTNGP12.phx.gbl...
> 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

[Mike K]

CW,

Actually custom formatting does work, as I have used this
in the past. Just format custom as ##":"##":"## then when
you enter 124545 you will get 12:45:45

Mike
>-----Original Message-----
>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
>.
>