Time Formating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to know how to format a cell for time. I need to have the cell formatted so that when I type in the cell say 125211 or 12 52 11 it will automatically appear as 12:52:11.
 

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

Compute minutes between hh:mm 2
Formatting cells with time 3
Excel Convert Datetime Stamp to HH and MM Worked 7
Conditional formatting in Excel 2010 2
Calculate and Format Time 5
Columns formatting 2
Excel 2002: Any formula to tranpose columns into rows ? 5
years-months-days-hours 5

Back
Top