Actually, mine rounds to the nearest 15 minutes, not down, as you said in
your question. Although I notice that your example rounded up.

Doug

"Doug Glancy" wrote in message
...
Alex,

I believe this does it:

=ROUND(((D12-C12)+(J12-I12))*(1440/15),0)/(1440/15)

hth,

Doug

"CAM" wrote in message
...
Hi,

I am trying to do a time sheet that will show number of hours. I need to
calculate hours worked each day and round them down to every 15 minutes.
For example if the employee work 7 hours and 22 minutes. I want to show
7 hours and 30 minutes in the calculated field. Below is the code I
created, but I am not sure if I am using the forumla correctly. I would
appreicate any tips. Thank you in advance.

cell D12 is Time Out, Cell C12 is Time in. Cell J12 is Time Out and
CI12 is Time In.
=FLOOR(((D12-C12)+(J12-I12)),0.0104166666666666)*24

Cheers.