Time zones and Time calculations

Classic Servoy
1

Hi All

I have a calculated field that converts a datetime field (formatted HH:mm) into a decimal equivalent (eg 3:45 = 3.75) using the calculation:

return (time_total.getTime() ) / (3600000)+ 10;

10 is the GMT time zone difference for Brisbane time.
As i deploy my solution across time zones this will change of course and produce incorrect values.

I assume that i can create a variable using date.getTimezoneOffset(); and incorporate that variable into the calculation.

Is this the best way to do it or is there another way to convert a time to a decimal equivalent without the timezones?