I want to have a column automatically fill in cells from 0 seconds up to say 30 minutes. So 1800? cells: 0,1,2...1:59, 2:00...30:00.
Also, stations. For surveyors. Auto fill column from 0+00 to 100+00.
I'm a noob.
I want to have a column automatically fill in cells from 0 seconds up to say 30 minutes. So 1800? cells: 0,1,2...1:59, 2:00...30:00.
Also, stations. For surveyors. Auto fill column from 0+00 to 100+00.
I'm a noob.
To list times in a column let's assume first time goes into A1:
A1: =TIME(0,0,ROWS(A$1:A1))
copy down to A1800
Regards your 2nd question...perhaps you mean ?
A1: =ROWS(A$1:A1)-1&" +00"
copied to A100
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks