Discussions

 View Only
  • 1.  Calculating a half a period

    Posted 08-10-2022 10:33
    Currently have a summary field that calculates the total of hours worked during a pay period  start and pay period end. I now need to calculate the total of hours halfway through the pay period.

    ------------------------------
    Willis Taylor
    ------------------------------


  • 2.  RE: Calculating a half a period

    Posted 08-10-2022 17:05
    You'll want a formula date field that is the date halfway through the period. You'll need to decide what 'halfway' means (if there are 15 days, is 7 or 8 days halfway through the period?).

    But in general - that date field would take the duration between the start and end date, divide that number by 2, then add it to the start date.

    So if the duration between 2 dates is 14 days, 7 days is the halfway point. Then add 7 days to start date ([Start Date] = Days(HalfDuration).

    Then use that for your summary field.

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 3.  RE: Calculating a half a period

    Posted 08-10-2022 17:19
    Willis
    is this a two week payroll period?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------