Rounding up a cell to the next ¼ hour.

[Pasquale]

I have a column that is tracking time spent on projects and an auto summation
at the bottom. However I would like to know how to formulate a cell that
take the total time and rounds it up to the next ¼ hour?

 

[Teethless mama]

=ROUNDUP(A1*96,0)/96

 

[ryguy7272]

Try:
=TIME(HOUR(A1),CEILING(MINUTE(A1),15),0)

This is a great resource:
http://www.cpearson.com/excel/datearith.htm

HTH,
Ryan---

 

[David Biddulph]

=CEILING(A1,1/96)