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...
OliverScheurich
May 22, 2023Gold Contributor
=44927+(ROW(1:1)-ROW($1:$1))/24In Excel 2013 you can enter this formula in row 1 and fill down.