formula
 

I need a formula. When entering numbers using a decimal point. The original
number must read as a decimal and not hrs:mn
For instance, 9.15 = 9hrs and 15 minutes I need the formula result to be
9.25 (the .25 is actually 25/100th of an hour)

9.05 should equal 9.08
9.30 should equal 9.50
9.45 should equal 9.75

--
bob

formula
 

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

"vdmbqb" wrote:

I need a formula. When entering numbers using a decimal point. The original
number must read as a decimal and not hrs:mn
For instance, 9.15 = 9hrs and 15 minutes I need the formula result to be
9.25 (the .25 is actually 25/100th of an hour)

9.05 should equal 9.08
9.30 should equal 9.50
9.45 should equal 9.75

--
bob

formula
 

This will work too:

=ROUNDDOWN(A1,0)+ROUND(RIGHT(A1,2)/60,2)

"vdmbqb" wrote:

I need a formula. When entering numbers using a decimal point. The original
number must read as a decimal and not hrs:mn
For instance, 9.15 = 9hrs and 15 minutes I need the formula result to be
9.25 (the .25 is actually 25/100th of an hour)

9.05 should equal 9.08
9.30 should equal 9.50
9.45 should equal 9.75

--
bob

formula
 

try 9.30 ....

"BriSwy" wrote:

This will work too:

=ROUNDDOWN(A1,0)+ROUND(RIGHT(A1,2)/60,2)

"vdmbqb" wrote:

I need a formula. When entering numbers using a decimal point. The original
number must read as a decimal and not hrs:mn
For instance, 9.15 = 9hrs and 15 minutes I need the formula result to be
9.25 (the .25 is actually 25/100th of an hour)

9.05 should equal 9.08
9.30 should equal 9.50
9.45 should equal 9.75

--
bob