Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Calculate Time Difference In Decimal Time

  1. #1
    Join Date
    15th August 2008
    Location
    Florida
    Posts
    17

    Calculate Time Difference In Decimal Time

    I've got a time difference from 8:00AM - 12:30PM as 4.30 I'm trying to get the minutes, .30, converted into a 6 minute increment, .5. Is it possible to do this and if so how would it be done? Below is a chart of how the time is converted from 6 minutes increments into decimal form. Thank You.

    6 = 0.1 36 = 0.6
    12 = 0.2 42 = 0.7
    18 = 0.3 48 = 0.8
    24 = 0.4 54 = 0.9
    30 = 0.5 60 = 1.0

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    19th January 2005
    Location
    Michigan, USA
    Posts
    844

    Re: Convert Difference Of Minutes Calced Into 6 Minute Increments

    What is it that you want? I don't follow...

    8:00 AM
    8:06 AM
    ======
    =((A2-A1)*1440)/60

    ...will result in 0.10

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    15th August 2008
    Location
    Florida
    Posts
    17

    Re: Convert Difference Of Minutes Calced Into 6 Minute Increments

    I would like the difference between 8:00AM and 12:30PM, which is 4 hours and 30 minutes (4.30). The minutes in this .30 I would like to convert into .50. I think I just need to figure out a formula that divides just the minutes by 6 but display the decimal. If I had a number of 4 hours and 24 minutes (4.24) I would like it to display as 4.4. Thanks for the reply.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    19th January 2005
    Location
    Michigan, USA
    Posts
    844

    Re: Convert Difference Of Minutes Calced Into 6 Minute Increments

    Umm, 08:00 AM - 12:30 PM equals 4.5 hours, not 4.3 and 4 hours and 24 minutes is not 4.24, it's 4.4; there isn't 100 minutes in an hour.

    I've also already provided you the formula

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    15th August 2008
    Location
    Florida
    Posts
    17

    Re: Convert Difference Of Minutes Calced Into 6 Minute Increments

    That works. ThanX!!!

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708
    If you wish to continue using this free service.

    Please be considerate of others who use the forum for searching. Your current Thread Title (which I will change) is non-reflective of what you are wanting to do.

    In future, please take 1 minute of your time to read the text on the New Thread page.

    Please take just 3 mins of your time to read: How To Get Your Question Answered...FAST! AND Anatomy Of A Good Thread Title

    REMEMBER: Your thread title should NEVER be what you THINK is your answer. 9 times out 10 it will wrong and prevent someone from finding a solution to a simliar issue.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Calculate Time Difference Between Decimal Time
    By jshayler in forum EXCEL HELP
    Replies: 4
    Last Post: August 21st, 2010, 03:58
  2. Calculate Time Difference In Decimal Hours
    By nme127 in forum EXCEL HELP
    Replies: 1
    Last Post: June 11th, 2008, 06:09
  3. Replies: 6
    Last Post: May 27th, 2008, 05:10
  4. Calculate Time Difference In Various Multiples
    By MikeBrough in forum EXCEL HELP
    Replies: 3
    Last Post: October 17th, 2007, 00:05
  5. Calculate Time difference between two Dates
    By BVic in forum EXCEL HELP
    Replies: 4
    Last Post: August 23rd, 2006, 10:08

Bookmarks

Posting Permissions

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