Converting Decimal to hours.

  • Thread starter Thread starter Steved
  • Start date Start date
S

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.
 
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
 
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
.
Click to expand...
 
Back
Top