**Finding the sum of multiple time intervals**

  • Thread starter Thread starter Soulja Boy
  • Start date Start date
S

Soulja Boy

I am making a schedule for my business and i need to figure out the total
amount in hours that each employee works. While I tried to do this I had
trouble entering the intervals (ie. 10am to 6 pm), and finding the sum of
them(ie. Monday to Friday)
-thankyou
 
In it's simplest form, start time in A2, end time in B2 use this formula in C2

=MOD(B2-A2,1)

then to calculate the sum for the week, assuming 7 days, use this formula in
C10

=SUM(C2:C8)

format C10 as [h]:mm, square brackets essential.....
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Analysis of measured test results by INTERVAL (variable) 2
Sum a Range Dependent on Non-zero Entries 2
request for time interval worksheet function 1
Keep total of cells in a cell after deleting source data 8
Time calculations for Scheduled Time vs. Actual Time Worked 1
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Time calculations for Scheduled vs Actual Employee Time and Wages 2
Determine if night shift by start & end time 2

Back
Top