How to calculate PPH using a start time and end time on same day.

Scott Kulefsky 0 Reputation points
2026-05-23T21:27:14.0666667+00:00

I'm trying to calculate the PPH of a dock door by busing the start time, end time time, and total packages but I keep getting errors. I've tried multiplying the time difference by 24 to convert the duration to a decimal and using the INT function.

Microsoft 365 and Office | Excel | For home | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-05-23T21:27:53.5433333+00:00

    Use the time difference directly, then divide packages by hours.

    Assume:

    • Start time in A2
    • End time in B2 (same day)
    • Total packages in C2
    1. Calculate elapsed hours (as a decimal): 
         =(B2-A2)*24
      Make sure A2 and B2 are valid Excel times (e.g., 8:00 AM, 2:30 PM).
    2. Calculate PPH (packages per hour): 
         =C2/((B2-A2)*24)

    If B2 is earlier than A2, or either cell is text instead of a real time value, Excel will return errors. Both cells must be proper date/time values on the same day.

    To display the elapsed time instead of decimal hours, you can also use:

    =B2-A2

    and format the result cell as h:mm or h:mm:ss as shown in the time-difference examples.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.