G
Gaby
I am trying to add payroll hours using excel. I know there is a really easy
solution to this but this is what I'm doing.
For example:
IN 6:06
OUT 11:34
IN 12:35
OUT 3:59
My formula to get total per day is =(A2-A1)+(A4-A3)
This formula IS giving me the right hours added, but when I add the totals
per day to get a total for payroll (2 weeks) I am getting some extremely off
number. My formula for that is just =SUM(C8+C13+C18+C23......)
Can anyone help me out?? I know I might need to format my totals so that it
adds hours and not time.
solution to this but this is what I'm doing.
For example:
IN 6:06
OUT 11:34
IN 12:35
OUT 3:59
My formula to get total per day is =(A2-A1)+(A4-A3)
This formula IS giving me the right hours added, but when I add the totals
per day to get a total for payroll (2 weeks) I am getting some extremely off
number. My formula for that is just =SUM(C8+C13+C18+C23......)
Can anyone help me out?? I know I might need to format my totals so that it
adds hours and not time.