Apr 18 2022 01:52 PM
Hi,
Is there a way to limit the numbers in a cell then rollover back to 0 when that limit is reached?
For instance, I only want to enable the amount 0-59 then have it restart back to 0. What I am looking to do is calculate the difference in secs between 2 sets of data;
E.g A) 123d33m50s
B) 321d33m10s
the diffrence then for A is 10s to reach 60 and for B is 10s to the nearest 60.
Is there a way to do this?
Apr 18 2022 02:25 PM
SolutionApr 18 2022 10:10 PM
@mtarler Thankyou! I used the 1st one and it worked amazingly. I have been trying to figure this out for a few days now so I very much appreciate the help!
Apr 18 2022 02:25 PM
Solution