Remove days from date and time

I have days, date and time in 1 cell, for a month with 1minutes interval.

Example: 

Sun, 1 jan 2018 12:00:00am

Sun, 1 jan 2018 12:01:00am

And continue untill full month.

 

My question, how to remove the days(sun,mon,tue,wed,thu,fri,sat)with fomula. 

By: Jrmuzam

Leave a Reply

Your email address will not be published. Required fields are marked *