software

A report I get regularly lists amounts of time in hours and parts of an
hour. However, the quot;parts of an hourquot; are units of 6 minutes, while the time
is listed in quot;pseudo-decimalquot; format, like this:

90 minutes would be 1.3 hours
12 minutes would be 0.12 hours

and so on.

I am trying to get the right formula to translate these into decimal hours,
so that

90 minutes would be 1.5 hours
12 minutes would be 0.2 hours

and so on.

The following works for positive numbers, but not negative numbers.

=INT(H2) ((H2-INT(H2))*10/6)

I have tried adapting this formula, but I am getting nowhere. Any
suggestions would be appreciated.

Do you mean this?

=(INT(ABS(H2)) ((ABS(H2)-INT(ABS(H2)))*10/6))*SIGN(H2)

Regards,
Stefi

?rian Clarke??ezt ?rta:

gt; A report I get regularly lists amounts of time in hours and parts of an
gt; hour. However, the quot;parts of an hourquot; are units of 6 minutes, while the time
gt; is listed in quot;pseudo-decimalquot; format, like this:
gt;
gt; 90 minutes would be 1.3 hours
gt; 12 minutes would be 0.12 hours
gt;
gt; and so on.
gt;
gt; I am trying to get the right formula to translate these into decimal hours,
gt; so that
gt;
gt; 90 minutes would be 1.5 hours
gt; 12 minutes would be 0.2 hours
gt;
gt; and so on.
gt;
gt; The following works for positive numbers, but not negative numbers.
gt;
gt; =INT(H2) ((H2-INT(H2))*10/6)
gt;
gt; I have tried adapting this formula, but I am getting nowhere. Any
gt; suggestions would be appreciated.
gt;
gt;
gt;
gt;

Yes, that's it! Many thanks for your help. Even after 10 years of Excel, I
am still learning. I wasn't aware of the SIGN function.quot;Stefiquot; gt; wrote in message
...
gt; Do you mean this?
gt;
gt; =(INT(ABS(H2)) ((ABS(H2)-INT(ABS(H2)))*10/6))*SIGN(H2)
gt;
gt; Regards,
gt; Stefi
gt;
gt; quot;Brian Clarkequot; ezt 甏ta:
gt;
gt; gt; A report I get regularly lists amounts of time in hours and parts of an
gt; gt; hour. However, the quot;parts of an hourquot; are units of 6 minutes, while the
time
gt; gt; is listed in quot;pseudo-decimalquot; format, like this:
gt; gt;
gt; gt; 90 minutes would be 1.3 hours
gt; gt; 12 minutes would be 0.12 hours
gt; gt;
gt; gt; and so on.
gt; gt;
gt; gt; I am trying to get the right formula to translate these into decimal
hours,
gt; gt; so that
gt; gt;
gt; gt; 90 minutes would be 1.5 hours
gt; gt; 12 minutes would be 0.2 hours
gt; gt;
gt; gt; and so on.
gt; gt;
gt; gt; The following works for positive numbers, but not negative numbers.
gt; gt;
gt; gt; =INT(H2) ((H2-INT(H2))*10/6)
gt; gt;
gt; gt; I have tried adapting this formula, but I am getting nowhere. Any
gt; gt; suggestions would be appreciated.
gt; gt;
gt; gt;
gt; gt;
gt; gt;
Hi Brian,

try this:

=(INT(ABS(H2)) ((ABS(H2)-INT(ABS(H2)))*10/6))*(H2/ABS(H2))

This will work for both negative and positive.

rgds

Andr?br />

quot;Brian Clarkequot; gt; wrote in message
...
gt;A report I get regularly lists amounts of time in hours and parts of an
gt; hour. However, the quot;parts of an hourquot; are units of 6 minutes, while the
gt; time
gt; is listed in quot;pseudo-decimalquot; format, like this:
gt;
gt; 90 minutes would be 1.3 hours
gt; 12 minutes would be 0.12 hours
gt;
gt; and so on.
gt;
gt; I am trying to get the right formula to translate these into decimal
gt; hours,
gt; so that
gt;
gt; 90 minutes would be 1.5 hours
gt; 12 minutes would be 0.2 hours
gt;
gt; and so on.
gt;
gt; The following works for positive numbers, but not negative numbers.
gt;
gt; =INT(H2) ((H2-INT(H2))*10/6)
gt;
gt; I have tried adapting this formula, but I am getting nowhere. Any
gt; suggestions would be appreciated.
gt;
gt;
gt;
You are welcome! Thanks for the feedback!
Stefi?rian Clarke??ezt ?rta:

gt; Yes, that's it! Many thanks for your help. Even after 10 years of Excel, I
gt; am still learning. I wasn't aware of the SIGN function.
gt;
gt;
gt; quot;Stefiquot; gt; wrote in message
gt; ...
gt; gt; Do you mean this?
gt; gt;
gt; gt; =(INT(ABS(H2)) ((ABS(H2)-INT(ABS(H2)))*10/6))*SIGN(H2)
gt; gt;
gt; gt; Regards,
gt; gt; Stefi
gt; gt;
gt; gt; quot;Brian Clarkequot; ezt ?rta:
gt; gt;
gt; gt; gt; A report I get regularly lists amounts of time in hours and parts of an
gt; gt; gt; hour. However, the quot;parts of an hourquot; are units of 6 minutes, while the
gt; time
gt; gt; gt; is listed in quot;pseudo-decimalquot; format, like this:
gt; gt; gt;
gt; gt; gt; 90 minutes would be 1.3 hours
gt; gt; gt; 12 minutes would be 0.12 hours
gt; gt; gt;
gt; gt; gt; and so on.
gt; gt; gt;
gt; gt; gt; I am trying to get the right formula to translate these into decimal
gt; hours,
gt; gt; gt; so that
gt; gt; gt;
gt; gt; gt; 90 minutes would be 1.5 hours
gt; gt; gt; 12 minutes would be 0.2 hours
gt; gt; gt;
gt; gt; gt; and so on.
gt; gt; gt;
gt; gt; gt; The following works for positive numbers, but not negative numbers.
gt; gt; gt;
gt; gt; gt; =INT(H2) ((H2-INT(H2))*10/6)
gt; gt; gt;
gt; gt; gt; I have tried adapting this formula, but I am getting nowhere. Any
gt; gt; gt; suggestions would be appreciated.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;