:00, :15, :30, :45 would be the quarter hours.

With the time in A1, you could use this formula in B1 (say)
=ROUND(A1/TIME(0,15,0),0)*TIME(0,15,0)

If you wanted to always to go the next quarter hour:
=CEILING(A1,TIME(0,15,0))

If you always wanted to chop to the previous quarter hour:
=FLOOR(A1,TIME(0,15,0))




RosaR wrote:

I am working on creating a timesheet in excel, I've got most of it figured
out, but now I need to convert my total hours to the nearest quarter(:25,
:50, :75, :00). For example: cell K5=7:50 (7 hours + 50 minutes), I believe
the nearest quarter hour should be 7:75 or 7.75, how can I get excel to do
this.

Plus at the end of the week I need to add up all the hours, with minutes
converted to nearest quarter. Please help me!!!!!

--

Dave Peterson