Time

[Neves]

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

 

[Mike H]

Try

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

Where A1 is start minutes
A2 is end minutes

Mike

 

[David Biddulph]

If you want an answer in decimal hours, use =(A1-A2)/60
If you want an Excel time, formatted as hours and minutes, use
=(A1-A2)/(60*24) and format as [h]:mm

 

[Mike H]

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

 

[David Biddulph]

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

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

Try

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

Where A1 is start minutes
A2 is end minutes

Mike

 

[Mike H]

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

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

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

Try

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

Where A1 is start minutes
A2 is end minutes

Mike

:

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