Military Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a time keeping database that uses military time for calculating hours
of work. However, some of these people get off of work at midnight and the
db will not let me enter 24:00. Fomatted as date/time, short time.
 
Try referring to midnight as 0:00, as technically midnight is not the end of
a day, but the beginning of one.
 
debug.Print #00:00# = 12:00:00 AM

It's the old "Is midnight 0000 hrs or 2400 hrs debate. Access sides with
00:00 so you'll have to change your users mind's. As a retired military man,
I know that you have your work cut out for you!

You could cheat and enter 23:59:59 . Close enough for government work!
 
Thanks, that did the trick. Now I have to go browbeat some users into doing
it as you said!!
 
Hey marie , Its simple ,ur BIOS Configuration needs alteraltion and it
should work there after
Take care
Sarathy
 
What the heck are you talking about? There's nothing in the BIOS that would
impact how Access treats Time values!
 
Hey marie , its pretty simple
Syncronize the software u are using with the BIOS time fiels and change
accordingly
Cya
Sarathy
 

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

24-hour clock format 4
Time format in a statement 8
Where to put an IIF in a query 2
military time 1
Use [StartDate] to get [StartTime] as text field 5
Time Calculation Over Midnite -- Where? 12
Military/24-Hour Time Validation Rule 1
Convert imported text to date time 2

Back
Top