help with hours minutes and seconds
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
.
|