Results 1 to 2 of 2
  1. 03-14-2013, 09:24 AM #1
    dadams
    dadams is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    1

    Question Calculating Military Time and putting the result to the nearest .25


    I have to fields in military time. I need to calculate and have the result in decimal format to the nearest .25 minutes.
    Reply With Quote Reply With Quote
  2. 03-14-2013, 10:16 AM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    See if this helps:

    http://allenbrowne.com/round.html#RoundTime
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Military Time Blues
    By viperbyte in forum Forms
    Replies: 19
    Last Post: 04-14-2020, 06:45 AM
  2. How do I calculate in Military time when the stop time is smaller than the start time
    By bjnorth in forum Access
    Replies: 42
    Last Post: 03-01-2013, 06:58 AM
  3. Formatting a text string as a time (military) without using Replace
    By sedonapinesit in forum Queries
    Replies: 14
    Last Post: 01-15-2013, 06:07 PM
  4. Calculating two fields in same form and displaying result
    By rhubarb in forum Forms
    Replies: 9
    Last Post: 09-26-2011, 09:16 PM
  5. Military Time
    By tshirttom in forum Access
    Replies: 3
    Last Post: 07-29-2011, 01:29 PM

Tags for this Thread

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums