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
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