Adding minutes.

G

Guest

Hello from Steved

6.05 a, 9.00 a , 1.00 p, 6.20 p adds to 8.15 Hours
now I will break the above into minutes as set out below

365, 540, 780, 1100 same as above but in minutes.

Please for the above minuteswhat formulawould i use to arrive at 8.15 Hours,
remmebering if you see a p I give it 720 mintes ie 1.00 p is 720 + 60 = 780
and the 6.20 p is 720 + 380 = 1100 Thankyou.
 
R

Roger Govier

Hi Steve

Format the cell with the formula as hh:mm
=--(INT(((540-365)+(1100-780))/60)&":"&MOD(((540-365)+(1100-780)),60))
 
G

Guest

Hello Roger

Thankyou.

Roger Govier said:
Hi Steve

Format the cell with the formula as hh:mm
=--(INT(((540-365)+(1100-780))/60)&":"&MOD(((540-365)+(1100-780)),60))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top