Thread
:
IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25
View Single Post
#
2
Peo Sjoblom
Posts: n/a
IN EXCEL, ROUND 10.45 T0 10.5 OR 10.27 TO 10.25
Refrain from using all caps, it is considered rude
=ROUND(A1*96,0)/96
--
Regards,
Peo Sjoblom
(No private emails please)
"JOE T" <JOE
wrote in message
...
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.
Reply With Quote