Forum Discussion
jphale65
Nov 02, 2024Copper Contributor
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, 1.1 and so on.
Any help would be appreciated.
Thank yoy
1 Reply
Sort By
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