You're welcome. Thanks for the feedback!

Biff

"Jorge" wrote in message
...
Thanks Biff,

Your formula is spot on now, working with all figures negative and
positive.
It's also given me some insight into dealing with some new scenarios.

Very much appreciated.
Jorge

"Biff" wrote:

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.