HS Explorer and MS Excel

sensor330 · 30th January 2006, 19:50

When cutting and pasting the dive profile from the HSE into MS Excel is there any way to convert the seconds into mins and seconds? I've tried to enter a variety on different functions with no success.

Scott

steevke · 30th January 2006, 20:01

You could write a VBA function - do integer division by 60 to get minutes, the remainder are your seconds.

HTH

Steven

sensor330 · 30th January 2006, 20:09

Could you explain VBA?

Janos · 30th January 2006, 20:16

Try: =TIME(,INT(A1/60),MOD(A1,60))

Where "A1" is the cell reference that contains the value in seconds.
You will also need to change the numberfomat to "mm:ss" (Ctrl+1; then number, then select "mm:ss")

Janos

steevke · 30th January 2006, 21:40

VBA = visual basic for applications, but you can use standard function as well.

=TIME(;;A1)
where A1 is the cell reference. Works on excel 2003.

Steven

sensor330 · 30th January 2006, 21:53

thanks

gathan · 30th January 2006, 23:01

Quote: (Originally Posted by sensor330)

When cutting and pasting the dive profile from the HSE into MS Excel is there any way to convert the seconds into mins and seconds? I've tried to enter a variety on different functions with no success.

Scott

I just wish I could do this with the RGBM profiles, but the software won't allow you to run the simulation.

Andre

seafox · 30th January 2006, 23:10

Quote: (Originally Posted by gathan)

I just wish I could do this with the RGBM profiles, but the software won't allow you to run the simulation.

Andre

Andre, in the Depth ansd BT enter: 825 & 828 - hit "run"

gathan · 30th January 2006, 23:46

Thanks a lot Seafox.

Andre

gathan · 30th January 2006, 23:58

Does anyone know why I get the "depth and bottom time must be greater than zero to generate table"?

I, of course have put in the requisite numbers in the boxes at the bottom. Is this a quirk witnin the program?

Andre

30th January 2006, 19:50	#1 (permalink)
sensor330 RBW Member Current Rebreather/s: Megalodon Other Rebreather/s: Not Bought Yet Inspiration Classic Join Date: Feb 2005 Location: Victoria, British Columbia, Canada Posts: 594	HS Explorer and MS Excel When cutting and pasting the dive profile from the HSE into MS Excel is there any way to convert the seconds into mins and seconds? I've tried to enter a variety on different functions with no success. Scott
(Offline)

30th January 2006, 20:01	#2 (permalink)
steevke Custom Title Allowed! Current Rebreather/s: Inspiration Vision Other Rebreather/s: Sport Kiss Join Date: Jul 2005 Location: Belgium Posts: 317	Re: HS Explorer and MS Excel You could write a VBA function - do integer division by 60 to get minutes, the remainder are your seconds. HTH Steven
(Online)

30th January 2006, 20:09	#3 (permalink)
sensor330 RBW Member Current Rebreather/s: Megalodon Other Rebreather/s: Not Bought Yet Inspiration Classic Join Date: Feb 2005 Location: Victoria, British Columbia, Canada Posts: 594	Re: HS Explorer and MS Excel Could you explain VBA?
(Offline)

30th January 2006, 20:16	#4 (permalink)
Janos "Two Sheds" Current Rebreather/s: Classic Kiss Other Rebreather/s: Classic Kiss Join Date: Feb 2005 Location: East Surrey Posts: 632	Re: HS Explorer and MS Excel Try: =TIME(,INT(A1/60),MOD(A1,60)) Where "A1" is the cell reference that contains the value in seconds. You will also need to change the numberfomat to "mm:ss" (Ctrl+1; then number, then select "mm:ss") Janos __________________ You can lead a horse to water but you can't climb a ladder with a large bell in both hands - Vic Reeves www.hellfins.com/shed
(Offline)

30th January 2006, 21:40	#5 (permalink)
steevke Custom Title Allowed! Current Rebreather/s: Inspiration Vision Other Rebreather/s: Sport Kiss Join Date: Jul 2005 Location: Belgium Posts: 317	Re: HS Explorer and MS Excel VBA = visual basic for applications, but you can use standard function as well. =TIME(;;A1) where A1 is the cell reference. Works on excel 2003. Steven
(Online)

30th January 2006, 21:53	#6 (permalink)
sensor330 RBW Member Current Rebreather/s: Megalodon Other Rebreather/s: Not Bought Yet Inspiration Classic Join Date: Feb 2005 Location: Victoria, British Columbia, Canada Posts: 594	Re: HS Explorer and MS Excel thanks
(Offline)

30th January 2006, 23:01	#7 (permalink)
gathan MixedGas Current Rebreather/s: Classic Kiss Other SCR Other Rebreather/s: Other SCR Join Date: Sep 2005 Location: Tottenham, Ontario, Canada Posts: 194	Re: HS Explorer and MS Excel Quote: (Originally Posted by sensor330) When cutting and pasting the dive profile from the HSE into MS Excel is there any way to convert the seconds into mins and seconds? I've tried to enter a variety on different functions with no success. Scott I just wish I could do this with the RGBM profiles, but the software won't allow you to run the simulation. Andre
(Offline)

30th January 2006, 23:10	#8 (permalink)
seafox 02ptima Instructor Current Rebreather/s: Inspiration Classic Optima Other Rebreather/s: Join Date: Mar 2005 Location: TORONTO, CANADA -Have "02ptima" will travel! Posts: 172	Re: HS Explorer and MS Excel Quote: (Originally Posted by gathan) I just wish I could do this with the RGBM profiles, but the software won't allow you to run the simulation. Andre Andre, in the Depth ansd BT enter: 825 & 828 - hit "run" __________________ Protect the SHARKS! Excellence is never an accident; it is always the result of high intention, sincere effort, intelligent direction, skillful execution and the vision to see obstacles as opportunities. Experience is a hard teacher because she gives the test first, the lesson afterwards!
(Offline)

30th January 2006, 23:46	#9 (permalink)
gathan MixedGas Current Rebreather/s: Classic Kiss Other SCR Other Rebreather/s: Other SCR Join Date: Sep 2005 Location: Tottenham, Ontario, Canada Posts: 194	Re: HS Explorer and MS Excel Thanks a lot Seafox. Andre
(Offline)

30th January 2006, 23:58	#10 (permalink)
gathan MixedGas Current Rebreather/s: Classic Kiss Other SCR Other Rebreather/s: Other SCR Join Date: Sep 2005 Location: Tottenham, Ontario, Canada Posts: 194	Re: HS Explorer and MS Excel Does anyone know why I get the "depth and bottom time must be greater than zero to generate table"? I, of course have put in the requisite numbers in the boxes at the bottom. Is this a quirk witnin the program? Andre
(Offline)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode