Time sheet in calculate per 15 minutes.
 

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.

Time sheet in calculate per 15 minutes.
 

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.

Time sheet in calculate per 15 minutes.
 

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.

Time sheet in calculate per 15 minutes.
 

"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.

Time sheet in calculate per 15 minutes.
 

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.

Time sheet in calculate per 15 minutes.
 

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


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

Time sheet in calculate per 15 minutes.
 

Thanks Doug. I appreicate your input.


"Doug Glancy" wrote in message
...
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.