Thread
:
If statement to compare time cell to a time
View Single Post
#
6
Posted to microsoft.public.excel.worksheet.functions
GS[_2_]
external usenet poster
Posts: 3,514
If statement to compare time cell to a time
wrote :
On Thursday, December 6, 2007 8:54:03 PM UTC+5:30, Luke M wrote:
Your welcome. Thanks for the feedback!
--
Best Regards,
Luke M
"Z-Man-Cek" wrote:
Good Stuff Luke - Thanks. It worked. - Russ
--
Z-Man
"Luke M" wrote:
Your time statements are wrong. You need to use commas to seperate, not
colons.
E.g, time(6,0,0)
--
Best Regards,
Hi I have two values in time format.
Its in hh:mm:ss
cell 1 is one time and cell 2 is another.
I need If time of cell 1 greater than cell 2 i want to print "late" in cell
3. If it cell 1 lesser than cell 2 then "EARLY"
if both the times are equal "Perfect"
How to solve?
In cell3...
=IF(Cell1Cell2,"Late",IF(Cell2Cell1,"Early",IF(C ell1=Cell2,"Perfect","")))
...where you need to substitute the actual cell address for 'Cell1' and
'Cell2' in the formula. This will not account for Cell1/Cell2 being
empty. If this is needed then...
=IF(AND(LEN(Cell1),LEN(Cell2)),IF(Cell1Cell2,"Lat e",IF(Cell2Cell1,"Early",IF(Cell1=Cell2,"Perfect" ,""))),"")
...where Cell3 will remain empty until both Cell1/Cell2 have content.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb
.general.discussion
Reply With Quote
GS[_2_]
View Public Profile
Find all posts by GS[_2_]