How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 32079
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

Greetings We just upgraded to office 2010 and discovered when

Resolved Question:

Greetings
We just upgraded to office 2010 and discovered when using xcel 2010 that the formulas were not the same as the 2003 version when making cell calculations. We need someone to help us put together an employee hours and rates of pay table, so that when the employee's hours are logged over three different daily shifts the table then calculates the weekly/fortnightly pays owing. I have created the table with all the sections but need someone to pout in all of the formulas.
Cheers
John
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Richard replied 4 years ago.

Professional Help :

Hi there and welcome

Professional Help :

you may not need to redo them

Professional Help :

can you follow this guide to convert the 2003 workbook to 2010

Professional Help :

this should then ensure the formulas work

Professional Help :

if you still have problems, please let me know

Customer:

That wont work as we started with 2010 can I send you a copy of the tablke so you can see what I mean?

Professional Help :

ok I see

Professional Help :

yes please upload the file to www.wikisend.com and supply me with the download link

Customer:

will do now

Customer:

the download link is http://wikisend.com/download/498080/PCW rates of pay timesheet.xlsx

Professional Help :

thanks, XXXXX XXXXX look at it now

Customer:

no worries

Customer:

how did you go

Professional Help :

looking at ti but it is giving very strange results

Professional Help :

but i see the problem now

Customer:

It is acting very strange

Professional Help :

yes, one issue is that it goes over midnight

Professional Help :

without that there is no problem

Customer:

Thats right. We have four main shifts two go over midnight

Professional Help :

ok, nearly done

Professional Help :

I forgot houw you caclulated

Professional Help :

















W/end Day
W/end PM
W/end O'night
W/end s'over
W/end O'lap

 

Professional Help :

but you can easily sum them now

Professional Help :

I will upload the file for you to check

Professional Help :

Can you please check it John

Professional Help :

http://wikisend.com/download/462510/PCW rates of pay timesheet.xlsx

Professional Help :

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?

Professional Help :

unless you can check it now?

Customer:

I will check it now

Professional Help :

thanks John

Customer:

The W/ends are the total for the weekends per shift so W/end Day is adding both Sat and Sun Day.

Customer:

These are still not right

Professional Help :

ok, finish checking so i have all the issues listed to fix at once please

Customer:

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

Professional Help :

ok, let me check

Professional Help :

ok, change the amount formula to this

Professional Help :

=(C3*D3)*24

Professional Help :

that works

Customer:

Thanks all good now.

Professional Help :

any other problems on the sheet?

Customer:

no. it looks good to go. Thank you

Professional Help :

your welcome

Professional Help :

please remember to click Accept if you are satisfied and enjoy your day!

Customer:

so do I just click accept notw

Professional Help :

yes please

Customer:

No worries take care

Professional Help :

you too!

Richard and 2 other Microsoft Office Specialists are ready to help you