May 05 2022 11:01 AM
Hi,
exported measurement values in excel, some Time cells are formatted different:
Time Value
1-May-2022 00:59:53 12,3
1-May-2022 00:59:43 12,8
...
01.05.2022 23:59:53 10
01.05.2022 23:59:43 10
...changes for approx. 994k rows.
How to change the date/format in dd.mm.yyyy hh:mm:ss?
Tried to format the cells with custom format but nothing happens.
Secondly, as you see time intervall of the measured values is 10 sec.
I would like to transform these values in an chart with average values per e.g. 15min, or 1h?
KR
Alex