Convert Number

  • Thread starter Thread starter Qui-Gon.Jinn
  • Start date Start date
Q

Qui-Gon.Jinn

Please can you help i want to type in say 9 into a cell but it will change
automatically to 09:00 and the same for 1130 to 11:30 and 12 to 12:00 i
have looked at formulas but cant work this out i can get 9 to 09.00 but not
what i want

Any help appreciated and Thnk you in advance
 
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

Tally the figures acquired from the same date 3
calculate total hours/minutes from two time cells 7
Finding if a certain time falls between two other times: 1
How to enter start and end date/time in excel based on some specific value. 7
Converting european date format to US format. 2
Using time values with an IF 4
Excel Catagorise AM or PM 7
Help with formula 1

Back
Top