IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25

[Guest]

TRYING TO ROUND TIME EQUATIONS TO THE NEAREST QUARTER HOUR. FIGURED OUT HOW
TO DETERMINE THE HOURS BETWEEN STARTING AND STOPPING TIMES, BUT WANT TO ROUND
THE RESULTING HOURS TO NEAREST QUARTER HOUR.

 

[Peo Sjoblom]

Refrain from using all caps, it is considered rude

=ROUND(A1*96,0)/96

--
Regards,

Peo Sjoblom

(No private emails please)

 

[topola]

In your example: 10.5 means half past ten and 10.25 means quarter past
ten? 10.45 is 27 minutes after ten?
If so you'd rather use:
=ROUND(D13*4,0)/4

Regards,
Tomek Polak, http://vba.blog.onet.pl