| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How calculate end time with beginning time plus formula minutes | Excel Worksheet Functions | |||
| Calculate total time(hours/minutes) from text/custom format column | Excel Discussion (Misc queries) | |||
| calculate time in days:hours:minutes | Excel Discussion (Misc queries) | |||
| to calculate the difference between sign in and signout time in minutes. | Excel Worksheet Functions | |||
| Calculate the time difference in minutes | Excel Programming | |||
Linear Mode
