formula

[Guest]

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

 

[Guest]

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

 

[Guest]

This will work too:

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

 

[Guest]

try 9.30 ....

This will work too:

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