AnsweredAssumed Answered

Excel to Filemaker - total time not matching

Question asked by JeffPimental on May 1, 2012
Latest reply on May 1, 2012 by JeffPimental

Title

Excel to Filemaker - total time not matching

Post

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?

Outcomes