Yes, I can provide a formula solution to convert a total number of seconds into a duration format (hours:minutes: seconds.milliseconds) 

Yeap check out this base.  Once you duplicate it to your own workspace you'll be able to use all the formulas and I set it up as one field each so that it's clearer how it works 

Thanks! This is probably a stupid question, but how can I duplicate this view? I tried copy and pasting the cells, but the formulas do not convert over. I only have view permissions, so I cant see open the filed editor to see the formulas either. There is no option that I see for exporting.

Ah, check out this guide for how to duplicate a base: https://support.airtable.com/docs/creating-a-new-empty-base#duplicating-airtable-bases