Using if in calculating hours
 

Hi...

This question is part of a weekly time recording sheet. I currently have set September month. 1st 7 columns is manually entered time using formatting hh:mm:ss and the next column is sum of the 7 columns using the formatting [h]:mm:ss.

I am trying to run a if statement where is the time is greater than 32 hours it should by Y in the cell k6 and if its less than 32 hours it should be N in the Cel K6.

I set this up

Logical test - I6time(32:00:00)
value_if_true - "Y"
value_if_false - "N"


But I am getting invalid in logical test.

Please suggest corrections.

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

Using if in calculating hours
 

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.

Using if in calculating hours
 

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

Using if in calculating hours
 

On Tuesday, 15 September 2015 10:15:28 UTC+5:30, wrote:
Hi...

This question is part of a weekly time recording sheet. I currently have set September month. 1st 7 columns is manually entered time using formatting hh:mm:ss and the next column is sum of the 7 columns using the formatting [h]:mm:ss.

I am trying to run a if statement where is the time is greater than 32 hours it should by Y in the cell k6 and if its less than 32 hours it should be N in the Cel K6.

I set this up

Logical test - I6time(32:00:00)
value_if_true - "Y"
value_if_false - "N"


But I am getting invalid in logical test.

Please suggest corrections.

Got it Thanks