Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement to compare time cell to a time | Excel Worksheet Functions | |||
Excel 2002: Can I compare 4 cells at one time ? | Excel Discussion (Misc queries) | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
compare time | Excel Discussion (Misc queries) | |||
compare time in IF statement | Excel Worksheet Functions |