Hey, glad to be back here!
I am automating some worksheets so that I can hand them over to someone else without them having to do (ideally any) manual effort. The file handles timesheet entries (people log the hours they work) and from there I run a pivot table that shows me hours worked per week/month/project etc
The source of my spreadsheet is a time & date field, coming from an external system. The values are exported in 2 US formats:
02/14/2019 07:15 AM - so mm/dd/yyy hh:mm AM
or
02/06/2019 08:32 - so mm/dd/yyy hh:mm
Using my manual solution I use the text to column to get these entries into a manageble dd/mm/yyyy format which Excel recognises. However, I want to avoid doing this type of manual manipulation if I can help it, so I just want to do this using formulas.
How would you do this? My attempts using TEXT, LEFT, WEEKDAY have not worked just yet.
Bookmarks