Try this:

=(INT(ABS(A1))+TRUNC(ROUND(MOD(ABS(A1),1),2)*0.6,2 ))*IF(A1<0,-1,1)

Biff

"Jorge" wrote in message
...
Thanks,

What you've given me produces similar results to bpeltzer's, however when
dealing with negative values e.g. 7.10 hours less (-7.10) than the
permitted
balance I get a result of -6.46 using the formula
=TRUNC(A5)+MOD(A5,1)*3/5;
and
-7.46 using the formula =INT(B43)+TRUNC(ROUND(MOD(B43,1),2)*0.6,2)
We're almost there.

Jorge


"Biff" wrote:

Try this:

The result is numeric and can be used in other calcs: (but then you'd
have
to figure out how to deal with values like these when added together:
3.50 +
3.10)

=INT(A1)+TRUNC(ROUND(MOD(A1,1),2)*0.6,2)

7.35 = 7.21

Biff

"Jorge" wrote in message
...
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.