Hi Bruce,

I've found that you're formula does'nt work with single digit decimal
negative figures - eg a mimum permitted balance of -8.16 equates to -7.50
instead of -8.09.

I hope someone is able to figure out this bit dealing with minus/negative
balances.

Jorge

"bpeltzer" wrote:

It seems as though you're entering hours in decimal form (that is, you're
entering numbers), and want to get back a number where the digits after the
decimal indicate the number of minutes. If that's the case, I believe the
formula =TRUNC(A5)+MOD(A5,1)*3/5 should do it (I've used A5 as the input
cell; you'll obviously adjust). You probably want to format the result as a
number with two decimal places.
--Bruce

"Jorge" wrote:

Hi Biff,

My Mistake I meant to type 7.35. In answer to yur question, no I won't be
using any converted figure in any calculations. I've tried to create an alert
to signal when a set number of hours has been exceeded. I've used the LEFT
and Right functions but I figure because it ignores zeros after the decimal
place the calculations are not right.

Jorge

"Biff" wrote:

Hi!

7.3 decimal = 7:18

Do you intend to use 7.21 as a numeric value in other calculations?

Biff

"Jorge" wrote in message
...
How do I convert 7.30 hours into 7.21 (ie 7 hours 21min.) Note I do not
wish
to use the standard hour:minute formatting.