Home |
Search |
Today's Posts |
#1
|
|||
|
|||
compare time
I would like to compare a calculated time in my work sheet vs. the actual
system time. For example, if the caculated time is than or = to the system time I want excel to tell me to "CALL", if not then "REST"...any help would be appreciated. Thanks, DE |
#2
|
|||
|
|||
Put your calculated time in a cell (say A1) In B1 put =NOW()
in C1 enter =IF(A1=B1,"CALL","REST) -- Gary''s Student "Eddie Munster" wrote: I would like to compare a calculated time in my work sheet vs. the actual system time. For example, if the caculated time is than or = to the system time I want excel to tell me to "CALL", if not then "REST"...any help would be appreciated. Thanks, DE |
#3
|
|||
|
|||
One way:
If your calculated value is in A1, then =IF(A1=MOD(NOW(),1),"CALL","REST") In article , "Eddie Munster" <Eddie wrote: I would like to compare a calculated time in my work sheet vs. the actual system time. For example, if the caculated time is than or = to the system time I want excel to tell me to "CALL", if not then "REST"...any help would be appreciated. |
#4
|
|||
|
|||
Student - did you test this?
Your formula should never result in "CALL", since NOW() returns a date and time, not just a time. If B1 contains =MOD(NOW(), 1), then the formula would work. In article , Gary''s Student wrote: Put your calculated time in a cell (say A1) In B1 put =NOW() in C1 enter =IF(A1=B1,"CALL","REST) |
#5
|
|||
|
|||
You are right JE. My calculated time was actually a date with time formatting
-- Gary''s Student "JE McGimpsey" wrote: One way: If your calculated value is in A1, then =IF(A1=MOD(NOW(),1),"CALL","REST") In article , "Eddie Munster" <Eddie wrote: I would like to compare a calculated time in my work sheet vs. the actual system time. For example, if the caculated time is than or = to the system time I want excel to tell me to "CALL", if not then "REST"...any help would be appreciated. |
#6
|
|||
|
|||
Thank you both...works like a charm!!!
"Gary''s Student" wrote: You are right JE. My calculated time was actually a date with time formatting -- Gary''s Student "JE McGimpsey" wrote: One way: If your calculated value is in A1, then =IF(A1=MOD(NOW(),1),"CALL","REST") In article , "Eddie Munster" <Eddie wrote: I would like to compare a calculated time in my work sheet vs. the actual system time. For example, if the caculated time is than or = to the system time I want excel to tell me to "CALL", if not then "REST"...any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup and compare to (today) + time and get result | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
entering numbers to display a time format | Excel Discussion (Misc queries) |