By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,565 Members | 907 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,565 IT Pros & Developers. It's quick & easy.

Time formats

P: n/a
Is it possible to format a time field to the 24hr clock. Been looking through
help and it seems to be suggesting that the machine settings are followed, but I
don`t want the machine on 24hr !
TIA
David B
Hexham UK

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies

P: n/a
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:br**********@newsg2.svr.pol.co.uk...
Is it possible to format a time field to the 24hr clock. Been looking through
help and it seems to be suggesting that the machine settings are followed, but I don`t want the machine on 24hr !


If you use a format string that does not include the "ampm" then you get 24 hour
format.

ex:

"h:nn:ss"
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 12 '05 #2

P: n/a
Try using =Format(DateVariable, "Short Time").

On Sat, 13 Dec 2003 14:54:33 -0600, Rick Brandt <ri*********@hotmail.com>
wrote:
"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in message
news:br**********@newsg2.svr.pol.co.uk...
Is it possible to format a time field to the 24hr clock. Been looking
through
help and it seems to be suggesting that the machine settings are
followed, but

I
don`t want the machine on 24hr !


If you use a format string that does not include the "ampm" then you get
24 hour
format.

ex:

"h:nn:ss"


--
"Justo, we have a problem!"
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.