G'day, Fellow Excel users.
I'm in need of assistance from greater experts on 'Userform, Textbox' work around. I have this 'Excel Workbook', which I'm quite familiar with and use quite often on some other projects. This time I decided to make a 'Logbook for my Diving'.
My issue which I cannot work around is getting the formulas in vba, as I have never attempted in the past, I would have thought they would be the some as a normal worksheet, managed to get one or two going but not the below.
I have a 'Column.H and Column.I' which calculate the dive time in minutes.
Time.A and Time.B
The formula is the product of Time.B – Time.A = to the dive time.
Column.H works fine
But, I need to convert this into minutes to work the 'Total Gas Used per Minute'
I tried several formulas but it got me beat I'm afraid.
I'll appreciate any help and assistance if some expert can throw some light on this issue.
I will upload the excel file as well.
I've used:
'Column H = Time Calculation, Time.B - Time.A
Me.textbox6 = Format(TimeValue(textbox5.Text) - TimeValue(textbox4.Text), "hh:mm")
Addme.Offset(0, 5).Value = Me.textbox6
'Column I = Time Calculation in Minutes
Me.textbox7 = Me.textbox6
'Me.textbox7 = Text(Me.textbox6 * 1440)
Me.textbox7.Text = Format(Me.textbox7.Text, "hhmm")
Addme.Offset(0, 6).Value = Me.textbox7