It look good to me except I would do 1 thing a little different

=FLOOR(((D12-C12)+(J12-I12)),TIMEVALUE("00:15"))*24




"CAM" wrote:

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.