SOLVED

Cell value restriction 0-59-0

New Contributor

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?

2 Replies
best response confirmed by Cllowry86 (New Contributor)
Solution
There are a few ways. Let's assume you have already have a way you are getting the 'sec' component. then here are 2 options:
=30 - ABS(30 - sec)
=ABS(MROUND(sec,60)-sec)
note that in testing it I found the 1st option let me use dynamic arrays while the second one did not.

@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!