Excel Time Question

[Steved]

Hello from Steved

3:55 p.m. is how Excel displays
My Question is if I delete p.m. it will display 15:55.

Therefore is it possible to display 3:15 if so how please.

Or can I split 3:55 to cell A1 and p.m. to cell B1.

Thankyou.

 

[Peo Sjoblom]

No, 3:55 PM = 15:55
3:55 without PM will always be 3:55 AM

Excel uses 24 hour

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

 

[Juan Sanchez]

Steved...

Bottom line is that those are two different numbers... the
day has actually 24 hrs so if you want to distinguish
betwen a.m. and p.m. you actually need that.

You could add a helper column with this formula:

=if(a1<.5,a1,a1-.5) and format "hh:mm" this will always
concider that the time is actually a.m.

But you still have the old column to remind you when not...

Then you said you cold have them divided so you can have
the helper column in A1 and the real column in B1...

so a1=if(b1<.5,b1,b1-.5) format hh:mm
and format b1 a.m./p.m. this will only display a.m. or p.m.
and in different cells....

Cheers
Juan

 

[andrea]

Yes, if you format the cell with a custom number format
as hh:mm then it will let you key the time without the AM
or PM.

Andrea

 

[Steved]

Thankyou

I felt this was the case (Oh Well)I just have to go down
another path.