I have this formula in my first cell
=TEXT(TIME(3,0,0), "H:MM AM/PM") & " to " & TEXT(TIME(3,15,0), "H:MM AM/PM")
It displays
I want to flash fill or create a formula that increases both times by 15 minutes as it goes down the column
so it will look like this
I’m thinking two ways I could achieve this are:
- write the formula to get the times of the previous cell and add fifteen minutes to both times
- write a formula to get the number of the row and add 15 *that number to both times
I, however, don’t know how to do either. Would appreciate help.
>Solution :
To add 15 minutes every row, do ROW()*15. and since it starts from the first row it should be (ROW()-1)*15.
=TEXT(TIME(3,0+(ROW()-1)*15,0), "H:MM AM/PM") & " to " & TEXT(TIME(3,15+(ROW()-1)*15,0), "H:MM AM/PM")

