IF statement to verify time have returned error output

**Faridwahidi** · 05-28-2014, 11:46 PM

Hi,

Can anyone please help me to resolve this,

E16 = 08:45 Cells Format, Custom hh:mm
H16 = 17:45 Cells Format, Custom hh:mm

=IF(AND(E16="08:45",H16="17:45"),TRUE,FALSE) have returned False, It should be True.

Really confused,

is it due to syntax error ?

Please help me

Regards,
Farid.

**FDibbins** · 05-29-2014, 12:08 AM

Give this a shot...
=AND(E16=TIME(8,45,0),H16=TIME(17,45,0)) (if you only want a TRUE or FALSE answer, you dont need the IF() part)

**Faridwahidi** · 05-29-2014, 01:22 AM

Hi FDibbins,

Thank you very much. I have added reputation to you.

**FDibbins** · 05-29-2014, 10:36 AM

Happy to help and thanks for the rep

IF statement to verify time have returned error output

LinkBack

Thread Tools

Rate This Thread

Display

IF statement to verify time have returned error output

Re: IF statement to verify time have returned error output

Re: IF statement to verify time have returned error output

Re: IF statement to verify time have returned error output

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need help with logic to parse through output being returned to excel from wsh

[SOLVED] Run-time error '424': Wrong value returned

If statement run time error

No value returned in if statement

[SOLVED] Run-time error '9' on With statement

Bookmarks

Bookmarks

Posting Permissions