Time Formula

[Ogogo]

Here is my formula =IF(I74=0,(NOW())-G74, I74-G74)

My question is that if both G74 and I74 are empty the the formula result show zero. My brain is fried today from the tracking sheet I have been updating for the past 60 hours. I am using this to track a technicians time and when I74 and G74 are populated it looks great. But I have reserved spots below with no data and would like the result to show zero or 0:00

 

[ttdk1]

=choose(if(i74=0,1,2),if(g74=0,0,now()-g74),i74-g74)

 

[Ogogo]

=choose(if(i74=0,1,2),if(g74=0,0,now()-g74),i74-g74)

Worked like a charm. Thank you very much!