IF a cell is blank show "empty" if not, add hours to it-CodePudding

Been trying to make this work for about a half hour or so and looking up references to ISBLANK or is null... isn't working as expected, even if it I reverse the THEN values.

What am I missing?

H4 =IF(ISBLANK(H3),"empty",B2 4/24) 
// H3: empty
// B2: 7:30 AM
// RESULT: 11:30 AM

H4 =IF(ISBLANK(H3),B2 4/24,"empty" ) 
// H3: empty
// B2: 7:30 AM
// RESULT: empty

Have looked at Google sheets help, various Stack Overflow answers, but still unable to get this to work.

ACTUAL OUTPUT

EXPECTED

CodePudding user response：

When the formula itself looks perfectly fine, but the result is not showing what you expected, try to test the input values with =ISBLANK(), =ISDATE(), etc. to see if there is any formating issue.

=IF(ISBLANK(H3),"empty",TEXT(B2 4/24,"hh:mm"))

you can also try formating the input data with TEXT() function.