Nested IF/ISBLANK statement

[smurkin28]

Hi guys,

First time poster looking for some help with a formula i am writing.
I am writing a formula that take date away from another to calculate the rest period between shifts

Here is where I am right now:

=IF(ISBLANK(J26),(I27-J25)+TIME(24,0,0),IF(ISBLANK(AND(J25,J26)),(I27-J24)+TIME(48,0,0),IF(ISBLANK(AND(J24,J25,J26)),(I27-J23)+TIME(72,0,0),IF(ISBLANK(I27),0,(I27-J26)))))


But the issue I am having is when J25,J26 are blank because there is a conflict where it also sees just J26 as blank.
Is the there a way to weight the true statementsso if one is true any others are ignored.

 

[Special-K99]

I think your "AND" IFs should take precedent over your individual IFs. You need to put the ANDs first

Try
=IF(ISBLANK(AND(J24,J25,J26)),(I27-J23)+TIME(72,0,0),IF(ISBLANK(AND(J25,J26)),(I27-J24)+TIME(48,0,0),IF(ISBLANK(J26),(I27-J25)+TIME(24,0,0),IF(ISBLANK(I27),0,(I27-J26)))))

 

[smurkin28]

I think your "AND" IFs should take precedent over your individual IFs. You need to put the ANDs first

Try
=IF(ISBLANK(AND(J24,J25,J26)),(I27-J23)+TIME(72,0,0),IF(ISBLANK(AND(J25,J26)),(I27-J24)+TIME(48,0,0),IF(ISBLANK(J26),(I27-J25)+TIME(24,0,0),IF(ISBLANK(I27),0,(I27-J26)))))

Thanks for input in coming to a solution,

this is something i have also tried with no luck
it still comes with the wrong value for example. when the value should be 3.63 i am getting numbers like this 42692.0416666088 because the conflict of more than one blank statement being true