Results 1 to 3 of 3

Thread: Times

  1. #1
    Join Date
    Nov 2005
    Location
    Live Oak, California
    Posts
    32

    Unanswered: Times

    I have a db with start time and stop time. I subtract these time to get the total. This works fine, my problem is I am unable to input 24:00.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Thats because like most computer environments Access doesn't rcognise 24:00 as a time, its 'clock runs from 00:00 - 23:59:59
    so it regards 24:00 as the start of the next day
    that means your calcualtion has just got a bit more complex, as you need to allow for times than span one or more days.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2005
    Location
    Live Oak, California
    Posts
    32
    Thanks forthe reply. I sort of had that hunch, that was the problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •