Results 1 to 3 of 3
  1. #1
    JDenham is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    15

    Question How to change a decimal of a minute into whole seconds in Access 2010


    I having great difficulty in changing a decimal of a minute into whole seconds; example 0.3 minutes into 18 seconds. I would like to use a update query that would take the [Downtime Min] and update a field in a table to [Downtime Sec]. I have searched the internet and have not found a suitable solution for this issue, I am sure I am missing something simple. Any help would be greatly appreciated.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    You should have a consistent unit of measure. If you record/store all of your minutes as seconds, you may reduce your issues.

    For example, 1 min = 60 seconds. So if you multiply all minute values by 60, you will get your result in seconds.
    For example, 5 Minutes = 5*60 seconds (300 seconds), 5.3 minutes = 5.3*60 (318 seconds).

    Value in minutes * 60 = value in seconds

    Good luck

  3. #3
    JDenham is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    15
    Thanks, that is what I thought, I was trying to over think it. I tried that but for some reason in my head it didn't look right. agian thanks for your help.

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

Similar Threads

  1. Change Image via Macro Designer Access 2010
    By joseinazusa in forum Macros
    Replies: 4
    Last Post: 01-15-2014, 06:14 PM
  2. Replies: 7
    Last Post: 04-23-2013, 11:57 AM
  3. Replies: 3
    Last Post: 04-21-2013, 06:48 AM
  4. Change layout on access 2010 contact database.
    By trumpetman in forum Access
    Replies: 0
    Last Post: 06-18-2012, 05:02 AM
  5. Change Access 2003 mdb workgroup using Access 2010
    By metsmaniac in forum Security
    Replies: 6
    Last Post: 04-06-2012, 08:56 PM

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