Mei_Mienzi
New Member
- Joined
- Apr 11, 2016
- Messages
- 20
I am trying to set up a spread sheet that will calculate the number of hours based on the times employees clock in and out each day and then give me a total for the time period.
I have found lots of templates but every last one of them has a problem I don't know how to overcome. If I have an employee that clocks in at 9 pm and clocks out at 12 pm (same problem with am times), when I put those hours into all of the templates am getting 9 hours.
I am also having trouble where an employee clock in at say 10 pm and clocks out at 3 am. In this case the spread sheet shows -19 hours.
To complicate matters further I have employees who work from am to am and from am to pm and visa-versa on the same time card.
Any suggestions or templates that really work?
Thanks
I have found lots of templates but every last one of them has a problem I don't know how to overcome. If I have an employee that clocks in at 9 pm and clocks out at 12 pm (same problem with am times), when I put those hours into all of the templates am getting 9 hours.
I am also having trouble where an employee clock in at say 10 pm and clocks out at 3 am. In this case the spread sheet shows -19 hours.
To complicate matters further I have employees who work from am to am and from am to pm and visa-versa on the same time card.
Any suggestions or templates that really work?
Thanks