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 The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1964
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

I'm looking with a semi-complex formula that will calculate

Customer Question

Hello, I'm looking for help with a semi-complex formula that will calculate "due date and time" for a case based on other known attributes of a case (i.e., received date & time and requested due time) I have a nice flow chart that explains the logic and decision points, I just don't know how to write the formula. I can send you my flow chart and an a sample set of cases if that helps.
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Richard replied 1 year ago.

Hi there and welcome

In which program is this formula for?

Customer: replied 1 year ago.
MS Excel 2013
Expert:  Richard replied 1 year ago.

Thanks

Please show me the flow chart that the formula will be based on

you can attach it here

Customer: replied 1 year ago.
sending files now.
Expert:  Richard replied 1 year ago.

ok, looking now

Expert:  Richard replied 1 year ago.

and in which cell does the formula go?

Customer: replied 1 year ago.
Column Q (Agreed Upon Due Date and Time)
Expert:  Richard replied 1 year ago.

ok, give me some time as I do this please

Customer: replied 1 year ago.
Sounds good. Thank you.
Expert:  Richard replied 1 year ago.

your welcome

Expert:  Richard replied 1 year ago.

sorry but I am not able to complete this. I am not able to get the date comparisons at that complexity to work correctly.

I will have to opt out. You do not need to do anything, when a new expert takes over, you will be notified.

Sorry I could not solve this for you.

Customer: replied 1 year ago.
Ok thank you
Expert:  The-PC-Guy replied 1 year ago.

i will take a look at this and see what can be done.

Customer: replied 1 year ago.
I'm trying to connect but it doesn't seem to be going through
Expert:  The-PC-Guy replied 1 year ago.

ok, I think there is a way to do this, but it will require a macro, to create a custom function to do this. It is just too complicated for the built in formulas.

are you opposed to using macros?

Customer: replied 1 year ago.
No, a macro is fine.
Expert:  The-PC-Guy replied 1 year ago.

ok, good i think that will make it easier.

So here is the deal, due to the complexity of the issue I believe that the question is worth more than the price you are offering.

To that end I am sending an additional service offer. If you accept it I will get started on this.

Expert:  The-PC-Guy replied 1 year ago.

ok, i appoligzie the site is experiencing technical difficulties

Expert:  The-PC-Guy replied 1 year ago.

i will be back with you as soon as possible

Expert:  The-PC-Guy replied 1 year ago.

to help you resolve this issue, I will need to have you open a new question and direct it to me.

to do this

---------------------------------------------------------------------------------------------------------------

you can visit my profile

http://www.justanswer.com/computer/expert-1expert-2rulethemall/

and ask a question right in my box,

also you can put "PC Guy only" in your question title if you want to get to me.

make sure "PC Guy" is somewhere in the title so I will pick up the new question.

The site said they would issue a credit if anything has been paid out on this question

Expert:  The-PC-Guy replied 1 year ago.

still waiting on that new question.

thanks

Related Microsoft Office Questions