On Tuesday, 15 September 2015 11:28:31 UTC+5:30, Claus Busch wrote:
Hi,
Am Mon, 14 Sep 2015 21:45:21 -0700 (PDT) schrieb
:
Logical test - I6time(32:00:00)
value_if_true - "Y"
value_if_false - "N"
time only works for 0 to 24 hours.
Try instead:
=IF(I64/3,"Y","N")
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Thanks it worked fine.
Can you help me in understanding the logic.
32 hours is 1 1/3 days!
4 divided by 3 = 1.333333333
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion