Rota - calculate the hours every one has done each week

**mrjaffa** · 11-19-2007, 09:27 AM

Hi everyone.

I'm not very useful with Excel but I've just finished doing my staff rota and was wondering if there is an easy way to calculate the hours every one has done each week to make sure everyone has done the correct hours. I was about to start using a calculator and then realised it would take forever, lol.

I've included a zip file of the excel file and I would REALLY appreciate it if anyone could take a look at it and advise me.

Thanks very much.

**oldchippy** · 11-19-2007, 09:46 AM

You may be better off redesigning your sheet so that it is easier to do the calculations, take a look at this link on TIME calculations

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

**mrjaffa** · 11-19-2007, 10:29 AM

Thanks for your reply.

I figured it would be difficult to do with my design, so if there is no way I'll certainly take your advice. I'll just add an extra column next to each day for hours worked that day and then calculate that way.

Now to try and remember how to do a simple sum like that.

:-)

**oldchippy** · 11-19-2007, 11:05 AM

May be something like this? I've completed the first column and top row and put the formulas in place.

**mrjaffa** · 11-19-2007, 02:31 PM

Hey again. Thanks for your help.

I've taken your advice and tried to re-design it, but I'm struggling.

Can you take a look at my latest effort and tell me why the sum function I've used to calculate the hours worked for one week doesn't seem to be working.

Thanks!

**oldchippy** · 11-19-2007, 06:41 PM

Can you attach your example

To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.