Hi, I want to convert a number for example 3,15 that represent (3h15min) into hour 3,25h. ,

[iralza01]

Hi I need to convert the following format into hours. I have the number 3,15 that represents 3h 15min, and I want to know how many hours with decimal are.

For example:

15min/60= 0.25h

so I want to transform 3,15 to 3.25.

Any suggestion?

[oknotsen]

Lets assume the field aNumber contains this information and you want to store it into newNumber:

floor(aNumber) + (frac(aNumber)/60)*100 as newNumber

[MK_QSL]

=Time#(3.15,'h.mm')*24