How do I set up Excel to display time as typed

G

Guest

I want to be able to format excel so that when I type 9.00 in a cell it
displays as 9.00 am. Every time i use time format and type it in it displays
as 12.00 am - why?
 
Y

yknet

JennyN said:
I want to be able to format excel so that when I type 9.00 in a cell it
displays as 9.00 am. Every time i use time format and type it in i
displays
as 12.00 am - why?
Click to expand...

Dear Jenny,

Excel can displays as you put in. You can chosse "text" category fro
format\cell menu. So it will show as 9.00 as you typed.
But the problem is you will not calculate further. If you want t
calculate (eg. duration), you should use type like 9:00. and fo
evening 4 o'clock as 16:00. You can choose time category fro
format\cell menu and then you choose 13:00 type in beyond box.

Hoping it's what you want
 

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

to find diffrence in time 3
How do I Return a Value Using Multiple Criteria? 1
I don't know which formula to use? 4
repeated conversion of data summarized into rows and columns 4
Get/Find criteria and copy sum 2
how to find time clashes using excel 7
how do i perform a Count(Distinct) query for 2 different column va 1
Time Format 1

Top