Convert hour to decimal value

[Anonymous]

Hello, what I am trying to do is get the values from two dropdowns and make them time value type, and then get the decimal value. something like "2:30"  would be 2,5.

When I try: 

TimeValue((Dropdown1.Selected.Value & ":" & Dropdown2.Selected.Value))/1000/60/60

It gets me a plus five difference son "2:30" gives me 7,5.

Any helpo or suggestions on how to do this would be great, thanks

[CarlosFigueira]

The difference you're seeing is likely due to the time zone information from your location. There are a couple of options you can use:

• Use math directly on the values of the dropdown controls:

Value(Dropdown1.Selected.Value) + Value(Dropdown2.Selected.Value) / 60

• Remove the time zone offset from the time information. The TimeValue function will create a time value from the "zero" date, which is 1970-01-01, so if we remove the timezone offset from that date, you should get the value you need:

TimeValue(("2" & ":" & "30"))/1000/60/60 - TimeZoneOffset(Date(1970,1,1))/60

Hope this helps!