Thread
:
Using if in calculating hours
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
Using if in calculating hours
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch