Results 1 to 9 of 9

Thread: [RESOLVED] using hh:mm:ss counting format in Access

Threaded View

  1. May 2nd, 2005, 12:18 PM #1
    Br1an_g
    Br1an_g is offline

    Thread Starter
    Addicted Member
    Join Date
    Jan 2002
    Location
    Glasgow, Scotland
    Posts
    202

    Resolved [RESOLVED] using hh:mm:ss counting format in Access

    i have an excel spreadsheet that has time in format:

    hh:mm:ss

    not in the sense of a time, in the sense of an incremental counter.

    when i import to access, it does not recognise this format and instead formats as text.
    if you change to time it changes it to am, pm time and removes any count that is greater than an expected time.

    any way to get this to work in access? the spreadsheet is getting a bit big and cumbersome.

    TIA
    Last edited by Br1an_g; May 4th, 2005 at 01:17 PM. Reason: resolved
    if you fail to plan, you plan to fail
    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