time compare in Excel
 

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 ?

time compare in Excel
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Sushrut Sardeshmukh wrote:
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 ?

time compare in Excel
 

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)

"Sushrut Sardeshmukh" wrote in message
om...
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 ?