Hi,

The wrong answer!!

My first formula was correct but I messed up on the second by not checking
it properly. thanks for the correction.

Mike



"David Biddulph" wrote:

So if A1 is the OP's 10020 minutes and A2 is 20000 minutes, what answer does
your formula give?
What does =(A2-A1)/(60*24) give, formatted as [h]:mm ?
--
David Biddulph

"Mike H" wrote in message
...
Another way if you want to do further calculations on the time

=TIME(INT((A2-A1)/60),(MOD((A2-A1),60)),0)

Format as [hh]:mm

Mike

"Mike H" wrote:

Try

=INT((A2-A1)/60)&" Hrs "& (MOD((A2-A1),60))&" mins"

Where A1 is start minutes
A2 is end minutes

Mike

"Neves" wrote:

My problem is that I have mins that look like 10020 total mins which
are mins
a forklift has been running I need to take that number and subtract it
from
another number like it and format it in to hours