Discussions

 View Only
  • 1.  Summary Field

    Posted 06-17-2020 17:10
    I'm trying to create a table to record hours for truck drivers in our company. Each day, they record hours worked and hours driven, along with the date, truck number, etc. One of the columns on the sheet they're currently filling out is Daily Recap. This is a running total of hours worked (Doesn't include hours driven which is part of the hours worked). Each week that number starts over but is still recorded for the month on the sheet. 
    in other words:
    Day 1 8 hours 2 hours driving Daily Recap = 8
    Day 2 8 hours 2 hours driving Daily Recap = 16
    Day 3 8 hours 2 hours driving Daily Recap = 24
    Day 4 8 hours 2 hours driving Daily Recap = 32
    Day 5 8 hours 2 hours driving Daily Recap = 40
    Day 6 OFF
    Day 7 OFF
    Day 8 8 hours 2 hours driving Daily Recap = 8
    Etc.

    The problem I'm running in to is the Daily Recap number. I can't get a running total field to work. And if I do, how do I have it start over the following week and still show up on their monthly recap report. I don't want to create multiple tables to do this one thing and am looking for a way to get this running total to work.

    Thank you.

    ------------------------------
    Steve Pearson
    ------------------------------


  • 2.  RE: Summary Field

    Posted 06-18-2020 07:26

    I think I see what you're asking.  Are you trying to get the totals for the week?

    I have a formula that will work for you, but need to know a little more about your table structure.  Please describe the fields you are using.



    ------------------------------
    Paul Peterson
    ------------------------------



  • 3.  RE: Summary Field

    Posted 06-19-2020 13:17
    Driver Recap Table
    This is the table. I need the Weekly Hours Summary to total each week, then the overall total at the bottom will work fine for the month.
    Not a complicated table, just that one field is stumping me.


    ------------------------------
    Steve Pearson
    ------------------------------



  • 4.  RE: Summary Field

    Posted 06-19-2020 13:23
    Are the drivers working Monday - Friday?

    ------------------------------
    Paul Peterson
    ------------------------------



  • 5.  RE: Summary Field

    Posted 06-22-2020 11:46
    For the most part yes. Once in a great while, they'll work on a Saturday.

    ------------------------------
    Steve Pearson
    ------------------------------



  • 6.  RE: Summary Field

    Posted 06-22-2020 18:09
      |   view attached
    I have been able to do what I was needed without the field I mentioned using and manipulating the summary report. Thank you for your help.

    ------------------------------
    Steve Pearson
    ------------------------------