PC Review


Reply
Thread Tools Rate Thread

Re: Formula not being Friendly

 
 
Living the Dream
Guest
Posts: n/a
 
      9th Aug 2012
Hi

Firstly

You do not need to use the Value() in the time formula.
It works just as well without.

=IF(G2<H2,"Breached",G2-H2)

Secondly

Unless you have a 3rd logic eg Low, Medium & High ( of which you only
use Low/Medium), you will only need to do this:

=IF(C2="Medium",WORKDAY(E2,3)+E2-INT(E2),WORKDAY(E2,5)+E2-INT(E2))

And Lastly

In the format screen, select Custom and copy this in

d "Days", hh:mm:ss

It will display 5 Days, 10:20:20

HTH
Mick.
 
Reply With Quote
 
 
 
 
Living the Dream
Guest
Posts: n/a
 
      13th Aug 2012
ok

Rule 1. =I1="Breached"
Rule 2. =I1<=0.375
Rule 3. =IF(I1<=0.625,AND(I1>0.375))
Rule 4. =IF(I1<=1.25,AND(I1>0.625))
Rule 5. =I1>1.25

HTH
Mick.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Being theme-friendly Jeff Johnson Microsoft Dot NET Framework Forms 1 20th Feb 2007 05:11 PM
Networking and XP not user friendly. Help? =?Utf-8?B?cmFpbm1pcmFnZQ==?= Windows XP Networking 2 3rd Apr 2005 05:38 PM
Internet is not a friendly place! Mike P Windows XP General 0 27th Oct 2003 03:00 AM
Administrator not coming up in friendly logon welcome screen Tom Dawson Windows XP Security 0 22nd Jul 2003 07:17 PM
Re: Administrator not coming up in friendly logon welcome screen Miha Pihler Windows XP Security 0 22nd Jul 2003 05:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:37 AM.