I'm looking to calculate the percent change in time. I have time as 1:14 and 2:05. I guess I can format it any way needed (do I need to format it any specific way). I also converted it to minutes.
The formula I'm using is..... (new value - old value )/old value * 100
Thanks,
d
The formula I'm using is..... (new value - old value )/old value * 100
Code:
=((J16-J15)/J15)*100
Thanks,
d