12 Hour Clock Format

February 12, 2011 at 15:41:49
Specs: Windows 7
I want to show 12 hour clock format but without the AM/PM.
That is, show 1:22 PM as 1:22 not as 1:22 PM.

See More: 12 Hour Clock Format

Report •


#1
February 12, 2011 at 17:10:34
Perhaps it would help us help you if you told us in what application you want this "clock formatting" done.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 14, 2011 at 06:07:28
Well, I have a spreadsheet with times of golfers should have for holes on a golf course. Called "pace times". It's a 20 x 70 sheet and I want to print it on one piece of paper (front and back). Using the 24 hour clock format makes it too long. If I could use the 12 hour format can get it in one 8.5 x 11.

Report •

#3
February 14, 2011 at 07:05:03
Format..Cells...Time...13:30

Should be the second one on the list.

See here:

http://assets.gcflearnfree.org/topi...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
February 14, 2011 at 07:23:52
"Using the 24 hour clock format makes it too long."

With a fixed width font, as normally is the case in spreadsheets (especially when printing) 11:30 and 23:30 take the same space. Are hours above 9 shown in hex?

Nigel

Mobo: Asus P7P55D LE
OS: Microsoft Windows 7 Professional OEM
CPU: Core i5 750 @ 2.67 GHz
RAM: Corsair Dominator DHX+ DDR3 1600MH 4GB
GPU: Sapphire 4870 D


Report •

#5
February 17, 2011 at 06:11:19
Nigel, you are right they do take up the same space more or less. But I am interested in the readablity of the times. This is a preference in that I want it to look like: "12:26 12:40 12:54 1:10 1:24 1:38" rather than: "11:44 11:56 12:12 12:26 12:40 12:54 13:10 13:24 13:38"

Report •

#6
February 17, 2011 at 06:28:10
Format...Cells...Custom

h:mm

This will show 1:22 PM as 1:22, but you may run into problems when doing time calcualtions since Excel is going to consider that to be 1:22 AM.

Since Excel stores Dates and Times as serial numbers, the serial number for 1:22 AM is not the same as the serial number for 1:22 PM. Obviously Excel can't "guess" at which 1:22 you mean.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#7
February 17, 2011 at 11:47:05
Don't know but I tired h:mm and it still shows 1:22 PM as 13:22. I went to the Control Panel and the Date & Time and changed the Short Time but still no dice.
Should have mentioned I have Excel 2003 in a Win 7 system.

Report •

Ask Question