24 hour time in Access

G

Guest

Is there any way to display the time in MS Access in a 24 hour format that
includes the seconds. So far all I find is "short time" which is hours
minutes only. I need to show the seconds also, but would prefer the 24 hour
format. Any help is appreciated.

Thanks
Dave
 
G

Guest

2 methods

1) set control panel in windows

2) use format function (i prefer use this method may be better, since
different PC has different setting in control panel)
e.g. Format(YourTimeValue, "H:nn:ss")

"DaveN" 來函：
 

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

How to return a 12 hour time format without the AM in an Access query 2
24-hour clock format 4
Format an Access calculation to display in full 24 hour mode 12
Time cell with colons 1
Sum Hours over 24 hours in Access Report 0
Military/24-Hour Time Validation Rule 1
Adding times that exceed 24 hours? 6
Format Time . . . Not 12-/24-Hour Format 5

Top