Database Admin

详细信息

I have a combined spreadsheet of invoice charges from October 2021 to February 2023.
This is approx. 650 rows of data. This is shown in the attachment (Example of Original Data).
I need 5 columns populated on a separate tab from this data with the following headings:
1. Date2. Description3. Time/Duration4. Rate5. Amount
This is to be organised like the attachment 'Centralised Costing Sheet'.
The date format on some rows moves between UK (DD/MM/YYYY) and US (MM/DD/YYYY), which would need to be standardised to UK format.