Hi there and welcome
you may not need to redo them
can you follow this guide to convert the 2003 workbook to 2010
this should then ensure the formulas work
if you still have problems, please let me know
That wont work as we started with 2010 can I send you a copy of the tablke so you can see what I mean?
ok I see
yes please upload the file to www.wikisend.com and supply me with the download link
will do now
the download link is http://wikisend.com/download/498080/PCW rates of pay timesheet.xlsx
thanks, XXXXX XXXXX look at it now
how did you go
looking at ti but it is giving very strange results
but i see the problem now
It is acting very strange
yes, one issue is that it goes over midnight
without that there is no problem
Thats right. We have four main shifts two go over midnight
ok, nearly done
I forgot houw you caclulated
but you can easily sum them now
I will upload the file for you to check
Can you please check it John
http://wikisend.com/download/462510/PCW rates of pay timesheet.xlsx
John, I need to sign off soon, but if you post your feedback here (or click accept if you are happy with the results) then I can resolve any issues you find first thing tomorrow if this is ok?
unless you can check it now?
I will check it now
The W/ends are the total for the weekends per shift so W/end Day is adding both Sat and Sun Day.
These are still not right
ok, finish checking so i have all the issues listed to fix at once please
I have fixed the weekends myself so good to go there. But when the C and D columns are multiplied together they do not end up with the right sum
ok, let me check
ok, change the amount formula to this
Thanks all good now.
any other problems on the sheet?
no. it looks good to go. Thank you
please remember to click Accept if you are satisfied and enjoy your day!
so do I just click accept notw
No worries take care