Numpty question about wages spreadsheet...

Latest Articles

Numpty question about wages spreadsheet...

Downsizer Forum Index -> IT Matters

Author

Message

sean
Downsizer Moderator

Joined: 28 Oct 2004
Posts: 42219
Location: North Devon

Posted: Thu May 07, 09 6:53 pm Post subject: Numpty question about wages spreadsheet...

At The Plough we have to fill out a time sheet every month. I was wondering if this could be put on a spreadsheet. I presume you'd have a column for each member of staff and a row for each day. Then the variables are ï¿½x/hour weekday daytimes, ï¿½y/hour weekdays after 5.30, Saturday daytimes and Sunday daytimes, ï¿½z/hour Saturday and Sunday evenings. Then I thought it could do it all automagically instead of us all faffing around with calculators. We only need it to provide a gross pay figure 'cos the tax and NI are done by the accountants.

chez

Joined: 13 Aug 2006
Posts: 35935
Location: The Hive of the Uberbee, Quantock Hills, Somerset

Posted: Thu May 07, 09 7:16 pm Post subject:
Steady on old chap, you'll be giving up the quill next ... Wouldn't you want separate columns each variable? So each member of staff has four columns, one for each of your different hourly rates? Then for each month you'd have four sub-totals and a grand-total?

sean
Downsizer Moderator

Joined: 28 Oct 2004
Posts: 42219
Location: North Devon

Posted: Thu May 07, 09 7:27 pm Post subject:
I don't know, that's why I asked.

Barefoot Andrew
Downsizer Moderator

Joined: 21 Mar 2007
Posts: 22780
Location: In the 17th century

Posted: Fri May 08, 09 12:12 am Post subject:
Wot Chez said. How many staff members are there? A.