Then J.E.'s solution should work
--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"HT" wrote in message
...
..sorry for the confusion..

15 minutes and anything multiple of 15 remains the same..so 15 minutes =
15 minutes, 30 minutes = 30 minutes..45 minutes = 45 minutes, 60 minutes =
60 minutes..but..the catch is lets say you have:

1 hour and 19 minutes..that should equal 1 hour and 1/2 hour..or 50
minutes that should equal 1 hour..

35 minutes should round up to 45 minutes
52 minutes should round up to 1 hour

..its like that.

Thank you.


"JE McGimpsey" wrote in message
...
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.