Converting Decimal to hours.

[Steved]

Hello from Steved

If I add 1.34 and 1.30 I will get 2.64, which is right,
How do I treat the above as Hours and Minutes, so now if I
add 1.34 and 1.30 I will get 3.04 or 3:04

Thankyou.

 

[Charlie]

Hi Steved,

The only way I know is to change the 1.34 to a time
format. For example 1.34 chage to 1:34 and the 1.30 to
1:30. Do a sum on both times and you will get 3:04.

Charlie O'Neill

 

[Steved]

Thankyou Charlie.

-----Original Message-----
Hi Steved,

The only way I know is to change the 1.34 to a time
format. For example 1.34 chage to 1:34 and the 1.30 to
1:30. Do a sum on both times and you will get 3:04.

Charlie O'Neill
.