Text or numbers to hh:mm

  • Thread starter quinto via OfficeKB.com
  • Start date
Q

quinto via OfficeKB.com

I have a column that has numbers as followed 630, 530, 1030 represting times,
I need to convert these numbers to 6:30, 5:30, 10:30 and so on.

Thanks
Quinto
 

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

How can the font and size of (all) citation numbers be altered? 1
Adding rota 0
Amending meeting cancels all future meetings 0
converting numbers to time 4
Sorting and filtering text 0
Finding the proper style field and the numbered paragraph value within the style 0
Countifs or a pivot 1
Excel does not accept text format! 0

Top