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.

Hi Steve

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


--
Regards

Roger Govier


"Steved" wrote in message
...
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.

Hello Roger

Thankyou.

"Roger Govier" wrote:

Hi Steve

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


--
Regards

Roger Govier


"Steved" wrote in message
...
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.