Questions

My numbers dont add up, help

+
0 Votes
Locked

My numbers dont add up, help

carlosmlr
i have made a schedule in excel:
time in time out total hours worked
4:00 PM 10:00 PM 6:0
when this is entered for each day, then i made a formula to total the hours for the week, ok some problems here because when formatting i had to use different items so it would add up correctly, ie sometimes h:mm and sometimes [h]:mm, but now i am trying to add up all the hours using =SUM(X6:X26) and it wont add up??