HOW DO YOU ROUND TIME TO THE NEAREST QUARTER HOUR?
R Ron Rosenfeld May 4, 2004 #2 HOW DO YOU ROUND TIME TO THE NEAREST QUARTER HOUR? Click to expand... 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
HOW DO YOU ROUND TIME TO THE NEAREST QUARTER HOUR? Click to expand... 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
B Bob Phillips May 4, 2004 #4 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)
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)
