| Home |
| Search |
| Today's Posts |
|
#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 |
Threaded Mode
