Excel to Filemaker - total time not matching
I have an Excel spreadsheet with 193 line items. Column I contains a number representing # of hours (end time - start time). The total using =SUM(I1:I193) equals 478 hours. When I import the Excel data into filemaker I get 193 records with the start time and end time. I created a duration field (end time - start time) that looks correct on each row in a tabel view. But when I create a summary field of the duration, I am getting 464 hours total instead of the 478 showing in Excel?
I found the issue... there was incorrect time data in a "end time" cell. Instead of a time, there was just "pm"