I am attempting to do an if/and datevalue with sum

January 8, 2018 at 05:08:06
Specs: Windows 7
(Cell F16) (Cell H16)
2017-12-24 17:47:22 06:38:06

2017/12/25 06:38:06 AM (value in cell H16)

I need to ascertain the following: (I did the formulae in separate cells and the expected answer returned)

=F16=DATEVALUE("2017-12-24") TRUE
=H16>DATEVALUE("2017/12/24 00:00:00 AM") TRUE
=H16-DATEVALUE("2017/12/24 00:00:00 AM") 06:38:06

However when I combine the above I cannot seem to get the result which would be the hours from 24H01 to 06H38:

=IF(AND(F16=DATEVALUE("2017-12-24"),L16>DATEVALUE("2017/12/24 00:00:00 AM"),L16-DATEVALUE("2017/12/24 00:00:00 AM",))



See More: I am attempting to do an if/and datevalue with sum

Report •

#1
January 8, 2018 at 11:24:36
Why did you start another thread related to same question that you asked earlier?

Please go back to the original thread, read my comments and then continue the discussion there.

Thank you

DerbyDad03
Office Forum Moderator

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •
Related Solutions


Ask Question