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: 16842
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: 2 years ago.
Category: Microsoft Office
Expert:  Richard replied 2 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, Software Specialist
Category: Microsoft Office
Satisfied Customers: 16842
Experience: Over 15 year experience resolving Microsoft Office Issues
Richard and 4 other Microsoft Office Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 
Chat Now With A Microsoft Office Technician
Richard
Richard
IT Manager
902 Satisfied Customers
Over 15 year experience resolving Microsoft Office Issues