Adding time in increments

If I recall correctly, I used to be able to add increments of time by a formula with the simple use of +5M (and indeed other posts in this forum seem to agree)

However, in the current version, when I go to type 5M, I am presented with a number of formula options.

Is there any way to get this to work?

I simply want to create a row with time in 5 minute intervals EG

10AM

10:05AM

10:10AM

10:15AM

etc.

This used to be so easy, but it seems like recent "updates" have made it much more complicated to achieve?

Posted on Dec 2, 2021 6:30 AM

Top-ranking reply

SGIII

Level 8

37,562 points

Posted on Dec 2, 2021 3:31 PM

If the word for minutes in your language starts with an m then you can surround the 5m with straight (non-curly) quotes and you will be good to go, like this:

=A2+"5m"

You can also use this:

=A2+DURATION(0,0,0,5,0,0)

(If your region uses , for a decimal separate replace the , in the formula with ;)

View in context

Adding time in increments

Similar questions