Help with Formula with a check box

[northernwarrior]

Hopefully this comes across as fairly easy to understand.

when box is checked as true, I have the formula subtract 2 cells ( ex. B3-A1 ), however I need a formula that IF a value is in A2 as well as A1, and the box is checkmark as TRUE, then it will subtract from A2 ( ex B3-A2 ) instead of A1

Is this possible ?

Attached is the spreadsheet Im working on.

From a text box on spreadsheet

"Help Needed:

Forumla i4-j3 unless k3 has a value. if it does, I need i4-k3 if h3 is true. if false, then it stays at 00:00

so right now L3 shows 1:30 (6:00-4:30), but because K3 has a value L3 should be 1:00"

[Gregb11]

Maybe this in cell L3?

IF(H3=TRUE,IF(K3="",I4-J3,I4-K3),0),"")

[northernwarrior]

Maybe this in cell L3?

IF(H3=TRUE,IF(K3="",I4-J3,I4-K3),0),"")

Works like a charm !! Thank You

[Gregb11]

Glad it worked and thanks for the feedback and rep!