B
Brian Clarke
A report I get regularly lists amounts of time in hours and parts of an
hour. However, the "parts of an hour" are units of 6 minutes, while the time
is listed in "pseudo-decimal" 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.
hour. However, the "parts of an hour" are units of 6 minutes, while the time
is listed in "pseudo-decimal" 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.