Diving log help

[magic2finger]

Hi

I would like to get the dive log to automatically calculate N2 group (gas in blood) and the time it takes from one N2 group to the next.

See attachments for additional information.


Hope someone can help me. Thanks.

[Bo_Ry]

Please try

=INDEX('Diving tabel'!$C$2:$C$95,MATCH(CEILING(G17,3)*1000+G19*1440,'Diving tabel'!$A$1:$A$95*1000+'Diving tabel'!$B$1:$B$95))

[magic2finger]

It will select the wrong depth (meters) due to G17.3.
Tried to enter the correct meter from the diver's table.
6,9,12,15,18,21,24,27,30 meters.
Got it, but it rounded up the time even though it was right.

Example: Depth 12m
Bottom time: 00:45
N2: F (it should have been E)

Made some notes in the sheet.

[Bo_Ry]

Please try at G20
=LOOKUP(2,1/(G17*1000+G19*1440>='Diving tabel'!$A$1:$A$95*1000+'Diving tabel'!$B$1:$B$95/('Diving tabel'!$A$1:$A$95>0)),'Diving tabel'!$C$1:$C$95)

[magic2finger]

Itīs close, but it needs to round the time up to next letter inn the diving tabel sheet.

If the bottom time is 55 min it should show C. so it should go up to 60 min bottom time in the diving tabel sheet, but stil have 55 min in the bottom time in the Diving log sheet.
. Thatīs the problem.... The time need to go up to next letter if the time is higher than the previous time in diving tabel sheet.

Thank you so mutch for the help. This means a lot.

Sorry for no excel, have not excel on this computer....

[Bo_Ry]

Third time's a charm.

=INDEX('Diving tabel'!$C$1:$C$95,MATCH(1,INDEX(--(G17*1000+G19*1440<='Diving tabel'!$A$1:$A$95*1000+'Diving tabel'!$B$1:$B$95/('Diving tabel'!$A$1:$A$95>0)),),))

[magic2finger]

Iīm possible making a mistake. Canīt get it to work. Iīm replacing the , with the ;
Am I missing somthing?

[Bo_Ry]

Please see attached