Adding minutes.  
Author Message
aspa





PostPosted: Wed May 24 17:26:09 CDT 2006 Top

worksheet functions >> Adding minutes.

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.

Excel503  
 
 
Roger





PostPosted: Wed May 24 17:26:09 CDT 2006 Top

worksheet functions >> Adding minutes. 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




> 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.
>
>
>


 
 
Steved





PostPosted: Wed May 24 18:26:01 CDT 2006 Top

worksheet functions >> Adding minutes. Hello Roger

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


> > 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.
> >
> >
> >
>
>
>