Ask Your Question
0

Want to make a chart with automated time increments. [closed]

asked 2013-10-12 07:54:18 +0200

birdboy272 gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-11 05:35:21.819405

1 Answer

Sort by » oldest newest most voted
1

answered 2013-10-12 13:11:11 +0200

m.a.riosv gravatar image

updated 2013-10-12 18:57:11 +0200

In cell C4:

=C3+TIME(0;0;5)

and copy down.

Please look about TIME(hours;minutes;seconds) function in the help.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-10-12 07:54:18 +0200

Seen: 533 times

Last updated: Oct 12 '13