Time sheet in calculate per 15 minutes.

[CAM]

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.

 

[Joel]

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

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

 

[Doug Glancy]

Alex,

I believe this does it:

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

hth,

Doug

 

[Doug Glancy]

Alex,

I believe this does it:

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

hth,

Doug

 

[Doug Glancy]

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

 

[CAM]

Thanks Joel, I wasn't sure if I got it right.

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

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

 

[CAM]

Thanks Doug. I appreicate your input.

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