Forum Discussion
Make excel count in multiples of 10 but upto 60
Hello, I'm trying to create a table showing plus and minus of a minute. The baseline being 0. We go up in groups of 10 seconds but I can't seem to make chart stop at 0.5/-0.5 then switch to 1, ...
For example:
=TIME(0, 0, 10*SEQUENCE(60))
Format the spill range of the formula as time or using a custom format such as m.ss