# 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!   Register To Reply

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.  Register To Reply

3. ## Re: Calculate minutes from decimal values

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

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  Register To Reply

5. ## Re: Calculate minutes from decimal values

Post deleted  Register To Reply

6. ## Re: Calculate minutes from decimal values

Thank you!

This worked perfectly.   Register To Reply

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   Register To Reply