Help! How to round to nearest 15 min unit

[Rebecca]

Help! I work for a behavioral health company, and with
the implementation of HIPPA, we need to round our service
units down to the nearest 15 minute unit. Any ideas on
how to do this? Seems like I need set a marker on the
rounddown function, but have no idea how to do this..
Thanks!

 

[Andy B]

Rebecca

Try this:

=TIME(HOUR(A1),FLOOR(MINUTE(A1),15),0)

This is lifted straight from Chip's site:
http://www.cpearson.com/excel/datearith.htm

Andy.

 

[Bob Phillips]

Rebecca,

Try

=ROUND(A1*24*4,0)/4/24

--

HTH

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