Make excel count in multiples of 10 but upto 60

Question

Hello,&nbsp;I'm trying to create a table showing plus and minus of a minute.&nbsp;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, 1.1 and so on.&nbsp;&nbsp;&nbsp;Any help would be appreciated.&nbsp;Thank yoy

hansvogelaar · Answer

jphale65&nbsp;
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

Forum Discussion

Make excel count in multiples of 10 but upto 60