date/time format and average over period

%3CLINGO-SUB%20id%3D%22lingo-sub-3327026%22%20slang%3D%22en-US%22%3Edate%2Ftime%20format%20and%20average%20over%20period%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3327026%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3Eexported%20measurement%20values%20in%20excel%2C%20some%20Time%20cells%20are%20formatted%20different%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETime%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Value%3C%2FP%3E%3CP%3E1-May-2022%2000%3A59%3A53%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B12%2C3%3C%2FP%3E%3CP%3E1-May-2022%2000%3A59%3A43%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B12%2C8%3C%2FP%3E%3CP%3E...%3C%2FP%3E%3CP%3E01.05.2022%2023%3A59%3A53%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2010%3C%2FP%3E%3CP%3E01.05.2022%2023%3A59%3A43%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2010%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E...changes%20for%20approx.%20994k%20rows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20change%20the%20date%2Fformat%20in%20dd.mm.yyyy%20hh%3Amm%3Ass%3F%3C%2FP%3E%3CP%3ETried%20to%20format%20the%20cells%20with%20custom%20format%20but%20nothing%20happens.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecondly%2C%20as%20you%20see%20time%20intervall%20of%20the%20measured%20values%20is%2010%20sec.%3C%2FP%3E%3CP%3EI%20would%20like%20to%20transform%20these%20values%20in%20an%20chart%20with%20average%20values%20per%20e.g.%2015min%2C%20or%201h%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKR%3C%2FP%3E%3CP%3EAlex%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3327026%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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

0 Replies