Calculating Number Of Hours Worked In A Week????? Help!!!!!!
Posted by Alicia on July 17, 2001 12:26 PM
On my Weekly Schedule spreadsheet, I am trying to figure out how to make the last column calculate the number of hours worked in that week, by each employee. The hours entered for each day look like this:
Monday Tuesday Wednesday etc. . .
6:30 AM 6:30 AM 6:30 AM etc. . .
3:00 PM 3:00 PM 3:00 PM etc. . .
How can Excel calculate that this is 42.5 hours for the week and then display that to me in a decimal format? I've tried and tried and can't figure it out! Help me please?!!!!!!