I need to to start at 3:30 and automatically make the cell under it 3:35 and the 3:40 so on and so on.
So:
3:30
3:35
3:40
3:45
Is there a way to automate this?
I need to to start at 3:30 and automatically make the cell under it 3:35 and the 3:40 so on and so on.
So:
3:30
3:35
3:40
3:45
Is there a way to automate this?
In cell C4:
=C3+TIME(0;0;5)
and copy down.
Please look about TIME(hours;minutes;seconds) function in the help.