I'm not sure I follow. 0:45 rounded to the nearest 1/4 hour is 0:45, not
1:00. However, if you want 0:46 to round to 1:00, here's one way:

=CEILING(A1,TIME(0,15,0))

Format the cell as Time. Or, since XL stores times as fractional days
use the equivalent:

=CEILING(A1, 1/(24*4))

or, more efficiently

=CEILING(A1, 1/96)





In article ,
"HT" wrote:

I need to create a time sheet whereas I can insert the amount of time worked
on a particular issue and have it add up..the catch is that it has to be
rounded off to the highest 1/4 hour.

For example,

Time worked: 45 minutes

Rounded off to : 1 hour

Thank you.