time compare in Excel

  • Thread starter Sushrut Sardeshmukh
  • Start date
S

Sushrut Sardeshmukh

I have two columns that contain time of two runs of executables.

I want to fomrat looks of the (Format -> Conditional formating) cell
using follwoing rules

some color if both runs took same time
some another color if one run took more than 50% or other run time

Time display should be in format 40:25:10 (run took 40 hrs 25 min and
10 seconds).

Can you please help me to achive this in excel ?
 
F

Frank Kabel

Hi
if your values are in cells A1 and B1 try the following:
- select cell A1
- goto the conditional format dialog and enter the following formula
=A1=B1
- choose your format
- add a second condition and enter the following formula
=ABS(A1-B1)/B1>=0.5
- choose your second format
 
B

Bob Phillips

Assuming the values are in A1 and B1

use formulae of

$A1=$B1

for same time

and

MAX($A1,$B1)>(MIN($A1,$B1)*1.5)

for greater than 50% between

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top