Converting time period in hours
 

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.

Converting time period in hours
 

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.

Converting time period in hours
 

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.

Converting time period in hours
 

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.

Converting time period in hours
 

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.

Converting time period in hours
 

format the result as a number with two decimal places.

You have to round in the formula otherwise you could get incorrect results.

Biff

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

Converting time period in hours
 

Thanks,

What you've given me produces similar results to Biff'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


"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.

Converting time period in hours
 

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.

Converting time period in hours
 

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.

Converting time period in hours
 

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.

Converting time period in hours
 

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.

Converting time period in hours
 

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.