cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aar0n Member
Member

Re: How to make a calculated 'days' column

My newest question:

 

how would i edit this formula so that the counter works as is - until 1 shows up - then counts just the number of days. 

 

for example,

 

Hours OnlineDateLocationDays OnlineProduction
01/1/2017A00
01/2/2017A00
121/3/2017A15
241/4/2017A210
01/5/2017A35
241/6/2017A420
01/8/2017B00
01/9/2017B00
01/10/2017B00
241/11/2017B15
241/12/2017B25
51/13/2017B35
191/14/2017B410
01/15/2017B50
241/16/2017B620