Excel Time Sheet Not Adding Up total hours worked correctly 1

[EatonNickH]

I have tried to make an excel spreadsheet to keep track of the employees hours in my office. it's set up in the front office and they put in the time they clock in adn the time they clock out. i then have a cell that subtracts clock in time from clock out time and called that row hours. next i try to sum the row "hours" and it seems to work fine until it gets half way through the week adn it starts messing up the total hours. i was wondering if anyone could give me some help w/ why this won't work. i have formatted all the cells for military time as well. thanks
nick

 

[Dreamboat]

"Total hours" cells must be formatted as [h]:mm:ss or [h]:mm.

http://www.PiersonTech.com

dreamboat@nni.com
Brainbench MVP for Microsoft Word

 

[Dreamboat]

See Chip Pearson's info on time/dates in Excel at:

http://www.cpearson.com/excel/topic.htm

Also, sample timesheets for download.

http://www.PiersonTech.com

dreamboat@nni.com
Brainbench MVP for Microsoft Word

 

[mbarron]

I think you may be adding time instead of hours worked.

I'm gussing that what should be 25 hours of work is showing as 1:00. If this is the case you are adding time. If you weren't using military time it would be showing 16 hours of work as 4:00p

Format your hours for the day "hours (dec)" below as numbers and then multiply "hours" by 24. The multiplication by 24 is because time is expressed as a decimal part of the day - noon would be .5 or half a day.

First row is type of formatting (mil)=military time (num)=number
(mil) (mil) (mil) (num) (num)
in out hours hours (dec) cummulative
8:55 17:00 8:05 8.08 8.08
8:58 17:00 8:02 8.02 16.10
8:58 17:00 8:02 8.02 24.12
8:58 17:00 8:02 8.02 32.14
8:58 17:00 8:02 8.02 40.14
Mike