# Time Formula

#### Ogogo

##### New Member
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

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
=choose(if(i74=0,1,2),if(g74=0,0,now()-g74),i74-g74)

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

Worked like a charm. Thank you very much!

Replies
8
Views
206
Replies
12
Views
462
Replies
2
Views
226
Replies
2
Views
169
Replies
11
Views
271

1,207,089
Messages
6,076,517
Members
446,211
Latest member
b306750

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back