help with hours minutes and seconds

  • Thread starter Thread starter Rog
  • Start date Start date
R

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting to text file in multiple lines 3
minutes & seconds functions 3
subtract hours, not time of day 1
long to wide transformation with of panel data with many variables 0
MACROS DATES 4
Summing minutes and seconds 2
separating date and time 5
Concert number to time 1

Back
Top