ROUND TIME TO NEAREST QUARTER HOUR

[Guest]

HOW DO YOU ROUND TIME TO THE NEAREST QUARTER HOUR?

 

[Ron Rosenfeld]

HOW DO YOU ROUND TIME TO THE NEAREST QUARTER HOUR?

Here's one way, with your TIME in A1 (in a format Excel will recognize as
time):

=ROUND(A1/TIME(0,15,0),0)*TIME(0,15,0)


--ron

 

[Frank Kabel]

Hi
if you have a real time value try
=ROUND(A1/(15/24*60),0)*(15/24*60)

 

[Bob Phillips]

To complete the aet

=ROUND(A1*96,0)/96

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)