Forum Discussion
GregD230697
May 22, 2023Copper Contributor
Genrate Date and Hour : Hour by hour for day by day
Hi everyone, I would like to know how to generate an excel file allowing me to display date and hour (dd/mm/yyyy hh:mm) for a day so 23 lignes from 00:00 to 23:00 for the 01/01/2023 to the 31/12...
HansVogelaar
May 22, 2023MVP
If you have Microsoft 365 or Office 2021, enter the following formula in the cell where you want to begin:
=SEQUENCE(52608, , DATE(2023, 1, 1), 1/24)
The formula will spill to 52608 rows. Select the spill range and format it as dd/mm/yyyy hh:mm