# Calculate minutes from decimal values

1. ## 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. ## 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.

3. ## Re: Calculate minutes from decimal values

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

4. ## 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

Post deleted

6. ## Re: Calculate minutes from decimal values

Thank you!

This worked perfectly.

7. ## Re: Calculate minutes from decimal values

Originally Posted by samba_ravi
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

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

#### 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