Adding minutes.

S

Steved

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))
 
S

Steved

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))
 
Top