I’m trying to import an Excel spreadsheet that contain totals hours that has to be formatted in nh]:ss format to display correctly. However, when I import to Airtable it displays the result as date with time “1900-01-09 15:52” which is what is showing formula bar in Excel. Apparently Excel formatting does this to be able to SUM hours?? I’ve tried all the formats in Excel and this is the only one that shows my data in Excel correctly. I’ve tried different formats in Airtable, but it still sees it as a date with time. Has anyone else experienced this and come up with a solution?
Thanks