Time Format ?

[DW]

Cell A1 value is 3:51
in Cell A2 place formula =A1*24 and format A2 is general
A2 should show 3.85

I need a formula that would show A2 (3.85) to show to the nearest quarter
time, in this case A2 would show 3.75.

Thanks in advance

Dale

 

[Jerry W. Lewis]

For fraction format, you could use the custom format
# ?/4
For decimal format, you have to round it, you cannot simply format it.
=ROUND(A2*4,0)/4

Jerry