How to list multiple, repeating times in a column?

afre1996

New Member
Joined
Aug 9, 2016
Messages
3
Hi

I need to make an Excel sheet to make an animal observation paper. The list requires to observe the animals every 30 seconds so the list would look something like:

8:25 am
8:25 am
8:26 am
8:26 am
8:27 am
8:27 am
etc...

Is there a shortcut on how to make these times without having to manually typing each row?
Thanks!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
I have tried, but nothing happens.
Surely, something happens (maybe not what you expect), but if you place the formula in cell A2 and copy down, something will show up in those cells.
What exactly are you seeing in these cells?
Note that you may have a fractional number displaying. That is because Date/Time are stored as mumbers (specifically the number of days since 1/1/1900).
So you will need to change the format to a Time format to see the times like you are accustomed to seeing.
 
Upvote 0
Recursivly adding 30 seconds will get round off error pretty quickly. A cleaner formulation would be in A2

=$A$1+ROWS($1:1)*TIME(0,0,30)

and drag down. (The round off doesn't accumulate)
 
Upvote 0
Recursivly adding 30 seconds will get round off error pretty quickly. A cleaner formulation would be in A2

=$A$1+ROWS($1:1)*TIME(0,0,30)

and drag down. (The round off doesn't accumulate)


Your formula worked and really helped! This will greatly help in my research! Thank you so much!
 
Upvote 0

Forum statistics

Threads
1,226,729
Messages
6,192,696
Members
453,747
Latest member
tylerhyatt04

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top