Datedif function 1

[hp1976]

Folks

I need a favour. I want to calculate a Turnaround time by using excel functions. The data's will be look like this:

Recd Date Recd Time Replied Dt Replied Time Status
20/4/2008 3.25pm 21/4/2008 3.26pm NotMet
2/6/2008 11.05am 2/6/2008 10.00pm Met

Our requirement is to reply the request within 24 hours (exclude non-working days, i.e sat and sunday). I want to put an formula in the Status field to know what all the request are replied within 24 hours or not..

Can anyone help me on this?

Many thanks in advance

Regards
Hari Prakash

 

[xlbo]

=if(Weekday(A2)<>6,if((C2+D2)-(A2+B2)>1,"Not Met","Met"),if((C2+D2)-(A2+B2)>3,"Not Met","Met"))

Where your dates and times are in A22

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[hp1976]

Hi Geoff

Awesome.... Thanks a lot man... It worked perfectly...Initally struggled due to format of the data... then it rocks....

Thanks again...



Rgds
Hari

 

[kjv1611]

Did it really work? Did it really help?

--

"If to err is human, then I must be some kind of human!" -Me

 

[SkipVought]

Hari,

Here at Tek-Tips, you can get good, solid FREE advice. xlbo gave you a great TIP.

In the Lower Left-Hand corner of xlbo's post is a link that says...
[blue]
Thank xlbo
for this valuable post!
[/blue]
In this way, it indicates to other Tek-Tip members who brows this forum, looking for helpful information, that this is a valuable post. It is a tangible way of thanking xlbo, and it also show others that you are a grateful member.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}