Time Formula

Ogogo

New Member
Joined
Sep 19, 2014
Messages
2
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
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

ttdk1

Board Regular
Joined
May 21, 2014
Messages
189
=choose(if(i74=0,1,2),if(g74=0,0,now()-g74),i74-g74)
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,627
Messages
5,523,985
Members
409,551
Latest member
WillCaton

This Week's Hot Topics

Top