| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to calculate employee attendance
Looking for the best way to calculate employee attendance based on when they
log in and out for the day. It has to compare to the employees start/end time for each day of the week. Any suggestions? -- Life is an adventure, are you living it? These are just my opinions, please feel free to correct them if they are wrong. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Best way to calculate employee attendance
Is it as simple as subtracting one time from the other or am I missing the point? -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=539330 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Best way to calculate employee attendance
How do you subtract when the shift rolls over from one day to the next?
-- Life is an adventure, are you living it? These are just my opinions, please feel free to correct them if they are wrong. "mrice" wrote: Is it as simple as subtracting one time from the other or am I missing the point? -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=539330 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Best way to calculate employee attendance
Thanks mrice for your help. I found a site via another thread that seems to
have all my answers. http://www.cpearson.com/excel/datetime.htm#WorkHours thansk for the help. :) -- Life is an adventure, are you living it? These are just my opinions, please feel free to correct them if they are wrong. "Hanr3" wrote: Looking for the best way to calculate employee attendance based on when they log in and out for the day. It has to compare to the employees start/end time for each day of the week. Any suggestions? -- Life is an adventure, are you living it? These are just my opinions, please feel free to correct them if they are wrong. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate employee hours for employee evaluation? | Excel Worksheet Functions | |||
| Calculate the time an employee signed in and out plus rate per hr | Excel Discussion (Misc queries) | |||
| How do I calculate an employee timesheet in Excel? | Excel Worksheet Functions | |||
| Referencing a newly created worksheet | Excel Worksheet Functions | |||
| Employee schedule: I want it to calculate time entered such as 11. | Excel Discussion (Misc queries) | |||
Hybrid Mode
