| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
