Rounding up a cell to the next ¼ hour.
 

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?

Rounding up a cell to the next ¼ hour.
 

=ROUNDUP(A1*96,0)/96


"Pasquale" wrote:

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?

Rounding up a cell to the next ¼ hour.
 

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

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

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Pasquale" wrote:

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?

Rounding up a cell to the next ¼ hour.
 

=CEILING(A1,1/96)
--
David Biddulph

"Pasquale" wrote in message
...
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?