you could use left / right / mid ie a1 – “24/11/23 08:36:00″ use mid
= mid(A1, 10,2) will give you the hour ie extract from 10th character for 2 characters, ie 08 in this case.
if you convert the column to a date
then you could use =year(a1)&text(month(a1),”00″) to give format, 202311 for example.. (yyyymm are then always 6 characters) could do same for days =day(a1) , =hour(a1) etc
may be best to split out the time entirely in a new column, using mid function =mid(a1,10,8)
A1 =HOUR(A1) [ADDED TO COLUMN B] THEN
=IF(b1<8,”Night”,IF(b1>18,”Night”,”Day”))
then create a pivot, i hate the new style pivots that group dates, i’ll always created a month column as above, easier to sort data