Hi all,
I was hoping somebody could help with a query i have.
I have a date time field, from which i would like to extract the day of the week and the time (using MROUND) to round to nearest hour. It doesn't have to be MROUND if there is a simpler way to do this.
Date is cell A1 looks like
2019-01-02 11:43:21 YYMMDD HH:MM:SS
by putting this formula in cell B1 i can extract the time =TIME(HOUR(A1),MINUTE(A1), SECOND(A1))
by putting MROUND in C1 =MROUND(B1,1/24) i can get the time rounded off to the hour
by putting in =CHOOSE(WEEKDAY(A1),"Sun","Mon","Tue","Wed","Thu","Fri","Sat") in D1 it selects the day of the week for me
Is there a quicker or better way to get all this data and still retain the date format as i want to plot the results. Perhaps im wrong but converting to text doesnt order the Axis correctly when plotting.
Any help will be greatly appreciated.
Bookmarks