Adding minutes.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steved - 24 May 2006 23:01 GMT

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.

Reply to this Message

Roger Govier - 24 May 2006 23:26 GMT

Hi Steve

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

Signature

Regards

Roger Govier

> Hello from Steved
>
[quoted text clipped - 8 lines]
> = 780
> and the 6.20 p is 720 + 380 = 1100 Thankyou.

Reply to this Message

Steved - 25 May 2006 00:26 GMT

Hello Roger

Thankyou.

> Hi Steve
>
[quoted text clipped - 13 lines]
> > = 780
> > and the 6.20 p is 720 + 380 = 1100 Thankyou.

Reply to this Message