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!
Bookmarks