What is the name of your state (only U.S. law)? CA
The company that I work for has my manager calculate payroll manually by hand. What the company has my manager do is she calculates how many hours and minutes are worked in each day and after each day is calculated she adds them all up together to get how many hours and minutes an employee has worked.
The issue that I've found with how my manager calculates the time is that the minutes are only counting as an hour after 100 mins is reached instead of 60 mins.
An example is let's say:
8/9/15
Clock in: 11:06AM
Clock out for lunch: 3:18PM
Clock back in from lunch: 3:49PM
Clock out: 6:03PM
Total hours worked: 6 hours & 26 mins
8/10/15
Clock in: 2:00 PM
Clock out for lunch: 5:47PM
Clock back in from lunch: 6:24PM
Clock out: 9:32PM
Total hours worked: 6 hours & 55 mins
Now, the error is when the times are calculated together, like how my manager does, she gets 6:26 + 6:55 = 12.81
The 81 mins is NOT in time format and therefore, 81 mins actually equals 1 hour and 21 mins.
This is what I mean when one hour is not becoming one hour after 60 mins but in fact after 100 mins.
My manager keeps the time at 12:81 and keeps adding the other times. She gets 12:81 but it is actually 13:21 because the 81 mins needs to be converted into time format.
So, I asked her why she adds them together when clearly they need to be added separately. The hours need to be added and then the mins separately and the mins need to be changed into time format. She got upset and said this is how I was told to do. But clearly in adding this way I get paid less than what I actually worked.
So now, my question is am I wrong in how the calculations should be done? Another employee that I work with noticed this the other day as well and asked the manager and she proceeded to get upset again. We are thinking of just taking this issue to HR but before we do we wanted to get input. I've included photos to show how my manager calculates the times and how I feel the times should be calculated. Clearly there is a huge difference in hours/pay with how my manager calculates payroll.
How my manager calculates:
http://img.photobucket.com/albums/v731/lovesurf/FullSizeRender.jpg
How I feel it should be calculated. Hours first and then mins converted before being added to hours to get total time.
http://img.photobucket.com/albums/v731/lovesurf/FullSizeRender 1.jpg
As you can see, I added the hours first and got 51 hours. I then added the minutes and got 289 mins which is 4 hours and 49 mins.
The total I got was 55 hours and 49 mins. My manager got 54 hours and 29 mins. Huge difference.
Thank you for your help and assistance in advance!!
The company that I work for has my manager calculate payroll manually by hand. What the company has my manager do is she calculates how many hours and minutes are worked in each day and after each day is calculated she adds them all up together to get how many hours and minutes an employee has worked.
The issue that I've found with how my manager calculates the time is that the minutes are only counting as an hour after 100 mins is reached instead of 60 mins.
An example is let's say:
8/9/15
Clock in: 11:06AM
Clock out for lunch: 3:18PM
Clock back in from lunch: 3:49PM
Clock out: 6:03PM
Total hours worked: 6 hours & 26 mins
8/10/15
Clock in: 2:00 PM
Clock out for lunch: 5:47PM
Clock back in from lunch: 6:24PM
Clock out: 9:32PM
Total hours worked: 6 hours & 55 mins
Now, the error is when the times are calculated together, like how my manager does, she gets 6:26 + 6:55 = 12.81
The 81 mins is NOT in time format and therefore, 81 mins actually equals 1 hour and 21 mins.
This is what I mean when one hour is not becoming one hour after 60 mins but in fact after 100 mins.
My manager keeps the time at 12:81 and keeps adding the other times. She gets 12:81 but it is actually 13:21 because the 81 mins needs to be converted into time format.
So, I asked her why she adds them together when clearly they need to be added separately. The hours need to be added and then the mins separately and the mins need to be changed into time format. She got upset and said this is how I was told to do. But clearly in adding this way I get paid less than what I actually worked.
So now, my question is am I wrong in how the calculations should be done? Another employee that I work with noticed this the other day as well and asked the manager and she proceeded to get upset again. We are thinking of just taking this issue to HR but before we do we wanted to get input. I've included photos to show how my manager calculates the times and how I feel the times should be calculated. Clearly there is a huge difference in hours/pay with how my manager calculates payroll.
How my manager calculates:
http://img.photobucket.com/albums/v731/lovesurf/FullSizeRender.jpg
How I feel it should be calculated. Hours first and then mins converted before being added to hours to get total time.
http://img.photobucket.com/albums/v731/lovesurf/FullSizeRender 1.jpg
As you can see, I added the hours first and got 51 hours. I then added the minutes and got 289 mins which is 4 hours and 49 mins.
The total I got was 55 hours and 49 mins. My manager got 54 hours and 29 mins. Huge difference.
Thank you for your help and assistance in advance!!
Last edited: