Hello everybody
I need to create a time series format dd / mm / yyyy hh: mm, from the begin day to the end day of the month
With a jump of 10 minutes
Can someone help me.
thank you
Hello everybody
I need to create a time series format dd / mm / yyyy hh: mm, from the begin day to the end day of the month
With a jump of 10 minutes
Can someone help me.
thank you
I don't understand. Why not just put 01/01/2016 00:00:00 in A1, 01/01/2016 00:10:00 in A2, select A1:A2 and drag down about 4300 rows?
Ben Van Johnson
In A1 put the start day and time such as 2/1/16 0:00
Right click the fill handle to that cell and pull down and back up.
Choose 'Series' at the bottom of the pop up.
Choose 'Column'
For Step Value type in .0069444444
For Stop Value type in the numeric value for the first day and time of the next month such as for March 1, 2016 at 12:00 AM is 42430
Select OK.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Row\Col A B 1 01 Feb 2016 00:00 2 01 Feb 2016 00:10A2:=MROUND(A1+"0:10", "0:10")
Copy A2 down.
Entia non sunt multiplicanda sine necessitate
put the start date in A1
And put
=$A$1+ROW(A1)*TIME(0, 10, 0) in A2
drag down to suit.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thank you all for your suggestions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks