Results 1 to 1 of 1
  1. #1
    hawkins is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jun 2011
    Posts
    82

    Dealing with Short Time format


    I have data that has been imported as short time. I am trying to find percent different for reliability sake. I am dealing with reliability in a utilities company and the duration is in short time , 1:03. I am trying to do an equation like this: ([CEMI3]/(1:03))*100. I am wondering if that will work correctly/is this the best way to go about this. Any suggestions will be greatly appreciated!

    *Solved: I ended up using the Hour and Minute functions to take out those and created a new column that stored the converted value.
    Last edited by hawkins; 08-16-2011 at 03:03 PM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-07-2011, 07:58 AM
  2. Datepicker set to short date: displays time?
    By sprovoyeur in forum Forms
    Replies: 3
    Last Post: 07-19-2011, 06:24 AM
  3. Replies: 0
    Last Post: 02-28-2011, 10:26 PM
  4. Having trouble dealing with these textboxes
    By blacksaibot in forum Programming
    Replies: 2
    Last Post: 04-28-2010, 12:10 PM
  5. Race Sports Time format
    By flebber in forum Database Design
    Replies: 0
    Last Post: 09-13-2009, 08:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums