1 Reply Latest reply on May 1, 2012 10:24 AM by JeffPimental

    Excel to Filemaker - total time not matching

    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?