Results 1 to 2 of 2

Thread: Converting Time in Access query

  1. Oct 11th, 2004, 04:37 PM #1
    dimava
    dimava is offline

    Thread Starter
    Frenzied Member
    Join Date
    Jun 2000
    Location
    East Providence, RI
    Posts
    1,715

    Converting Time in Access query

    Is it possible to convert time from a format of (22:50) to 10:50 PM?

    thanks

    Dimava
    NXSupport - Your one-stop source for computer help
    Reply With Quote Reply With Quote
  2. Oct 11th, 2004, 04:57 PM #2
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132
    You may use ordinary Format(my_time, "HH:NN AM/PM") function.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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


Click Here to Expand Forum to Full Width