I've got a large excel spreadsheet filled with metadata (a large number of songs from the British Museum archives). I'm encompassing many difficulties. An example:

The original file has a song duration of 00:02:45, on the spreadsheet its written as 01091900.
For the same song, the original date is 1977-01. On the spreadsheet it is written as 11/09/4670 but presented at sep-70.

I'm wondering whether someone would be willing to help me on this, or if my best course of action is to continue to post these little problems here on the forum as I go along.

Thank you.