Home

Auto-Filling Dates 24 separate times (24 hour clock)

%3CLINGO-SUB%20id%3D%22lingo-sub-1032990%22%20slang%3D%22en-US%22%3EAuto-Filling%20Dates%2024%20separate%20times%20(24%20hour%20clock)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1032990%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%20a%20spreadsheet%20that%20shows%20the%20same%20date%2024%20times%20then%20moves%20to%20the%20next%20date.%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20-%3C%2FP%3E%3CTABLE%20border%3D%221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3EDate%20-%3C%2FTD%3E%3CTD%3ETime%20-%26nbsp%3B%3C%2FTD%3E%3CTD%3E(Other%20Data)%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01%2F01%2F2017%3C%2FTD%3E%3CTD%3E00%3A00%3A00%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01%2F01%2F2017%3C%2FTD%3E%3CTD%3E00%3A01%3A00%3C%2FTD%3E%3CTD%3E142%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E....%3C%2FTD%3E%3CTD%3E....%3C%2FTD%3E%3CTD%3E...%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EThen...%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E01%2F01%2F2017%3C%2FTD%3E%3CTD%3E00%3A23%3A00%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E02%2F01%2F2017%3C%2FTD%3E%3CTD%3E00%3A00%3A00%3C%2FTD%3E%3CTD%3E42%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20insert%20it%20automatically%20or%20autofill%20it%3F%20(I%20have%20to%20produce%20two%20years%20worth%20of%20data)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindest%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1032990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
TomHiggs
Occasional Visitor

I need to create a spreadsheet that shows the same date 24 times then moves to the next date. 

For example -

Date -Time - (Other Data)
01/01/201700:00:005
01/01/201700:01:00142
...........
Then...  
01/01/201700:23:000
02/01/201700:00:0042

 

Is there a way to insert it automatically or autofill it? (I have to produce two years worth of data)

 

Kindest regards

1 Reply
Highlighted

@TomHiggs 

If ignore Other column and Date, Time are located as

image.png

type in A3

=A2+1/24

in B3

=B2+1/24

select columns A and B starting from above cells and till end of your expected range, Ctrl+D.

Or drag them down.

Related Conversations
Bug with the widget in Microsoft Launcher Preview
HotCakeX in Report an Issue on
0 Replies
Teams no longer auto launches
trandall in Microsoft Teams on
4 Replies
Date filtering of Bing Searches
PhilipE3 in Discussions on
2 Replies
Setting Date in Stored Procedure
Tim Hunter in SQL Server on
1 Replies
How do I group rows in an excel table?
Marisa Medrano in Excel on
1 Replies