Hello Everyone,
Would appreciate your assistance on the following problem I have.
I may be going about this the wrong way but hopefully somebody can point me in the right direction?
So here is my problem, I have made a table in excel (2010) for calculating divers umbilical lengths (see attached)
Bailout Pressure - (Abs. Bar + Reg Bar) x BOB Litres Capacity = 1281 Litres
Breathing Rate (45lts/min) x Abs. Bar = 90 Litres per minute
45*2 = 90 Litres per minute
So using the figures above dividing capacity by requirement gives me a dive time
1281/90 = 14.23 minutes
14.23 decimal minutes (this is where i'm stuck) -
14.23 decimal minutes equate to 14 minutes 13.8 seconds
The Diver has 14 mins and 14 seconds available at 10 metres
Now the final calculation:
The divers needs to be able to travel at 10 metres every 1 minute
therefore 14.14 minutes x 10 metres = 141 metres
So what i would like is to show is this final 141 metres figure in my cell
I've managed to get to the 14.23 decimal minutes by doing this:
=SUM((C4)-(B4+L2))*(D3)/(B4*45)
=SUM((200)-(2+15))*(7)/(2*45)
=SUM(1281/90)
=14.23 minutes
How can i change 14.23 decimal minutes into actual minutes and seconds (14 mins 14 secs) then times by 10 to equal 141 metres
Preferably all in one formula? If possible....
or does this need other cells to make the calculations
Thanks in advance for any advice
Christian
Bookmarks