Thread: Adding minutes.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steved
 
Posts: n/a
Default 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.