convert number format to time format

  • Thread starter Thread starter fullymooned
  • Start date Start date
F

fullymooned

I have a whole column in which I need to be able to enter a number an
it should convert it to the time format. If I enter 100 it shoul
convert it to 1:00. Similarly entering 2300 should automatically b
converted to 23:00.

Thank yo
 
Hi fullymooned!

See:
Chip Pearson:
http://www.cpearson.com/excel/DateTimeEntry.htm

There's a tried and tested subroutine there.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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

Which is the best MBOX Converter Tool different formats conversion? 4
How to Convert MBOX to PST Online? 3
How to Export Gmail Emails to PST Format? 4
Data Validation when entering hours over 24 8
How can we convert OST to PDF file format? 1
How to Convert EML to PST? 2
single cell time entry as time - time; Ever seen this? 12
Time Calculations Help 4

Back
Top