how can I add hours in Excel?

[Guest]

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.

 

[Bob Phillips]

make sure that you format the total cell as [h]:mm

 

[rb]

in Format>Cells>Number, are all the cells formated as
time, xx:xx?