+ Reply to Thread
Results 1 to 7 of 7

Calculate minutes from decimal values

  1. #1
    Registered User
    Join Date
    08-07-2019
    Location
    Alberta
    MS-Off Ver
    Office 360 for Mac
    Posts
    3

    Question Calculate minutes from decimal values

    what I'm trying to do is calculate the total time for a set of minutes. I need everything to be in decimal format.

    for example:

    My equipment runs for a total of 10.24 mins. (10mins, 24 sec) but there was a pause in the sample time of 1.01. I would like an equation in excel that will calculate the total number of minutes my sample ran for. In this example the answer is 9.23. Obviously because of the 60mins it isn't as simple as 10.24-1.01.

    I hope the example makes it clear.

    Thanks!

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    It changes constantly, but based in Ireland.
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    25,371

    Re: Calculate minutes from decimal values

    Since time formatting can be a bit unusual, can you attach a sample Excel sheet with a few examples and manually calculated answers?

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,676

    Re: Calculate minutes from decimal values

    Try below
    =a1-b1-(mod(a1,1)<mod(b1,1))*0.4
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    12,646

    Re: Calculate minutes from decimal values

    If your times are truly entered as mm.ss (and this is not text or date/time serial numbers formatted as "mm.ss"), then I would use the DOLLARDE() and DOLLARFR() functions to convert the mm.ss values to decimal minutes, perform the subtraction, and then back to the mm.ss value.

    DOLLARDE(value,60) will convert mm.ss to decimal minutes.
    subtract the two values with the regular subtraction operator.
    DOLLARFR(value,60) will convert decimal minutes to mm.ss

    Put it all together and it might look something like =DOLLARFR(DOLLARDE(value2,60)-DOLLARDE(value1,60),60)

    DOLLARDE() function: https://support.office.com/en-us/art...d-a38476693427
    DOLLARFR() function: https://support.office.com/en-us/art...4-3042c5d4f495
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Forum Expert
    Join Date
    07-20-2011
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    5,088

    Re: Calculate minutes from decimal values

    Post deleted
    Last edited by kvsrinivasamurthy; 08-07-2019 at 10:24 AM.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  6. #6
    Registered User
    Join Date
    08-07-2019
    Location
    Alberta
    MS-Off Ver
    Office 360 for Mac
    Posts
    3

    Re: Calculate minutes from decimal values

    Thank you!

    This worked perfectly.

  7. #7
    Registered User
    Join Date
    08-07-2019
    Location
    Alberta
    MS-Off Ver
    Office 360 for Mac
    Posts
    3

    Re: Calculate minutes from decimal values

    Quote Originally Posted by samba_ravi View Post
    Try below
    =a1-b1-(mod(a1,1)<mod(b1,1))*0.4
    Thank you this worked perfectly!

    I don't understand it but its accurate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Converting a sum from decimal minutes to minutes & seconds then multiplying by 10
    By sparkyliveson in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-22-2014, 11:53 AM
  2. Replies: 1
    Last Post: 12-22-2013, 08:04 AM
  3. Replies: 13
    Last Post: 05-03-2013, 08:42 PM
  4. RE: Converting decimal minutes to hours, minutes and seconds
    By mills49 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-14-2013, 09:14 AM
  5. Want to calculate decimal time from minutes/seconds
    By Maytree in forum Excel General
    Replies: 6
    Last Post: 01-11-2012, 01:37 PM
  6. [SOLVED] Convert Decimal hours and Minutes to minutes please.
    By Steved in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-05-2006, 12:35 AM
  7. Replies: 2
    Last Post: 11-05-2005, 12:25 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1