AnsweredAssumed Answered

Calculating work hours

Question asked by guit4eva on Oct 3, 2017
Latest reply on Oct 12, 2017 by guit4eva

Hey guys,

 

I have a table set up like the following (per user):

 

Date             |   Hours Worked

01/01/2017   |   8

01/01/2017   |   5

03/01/2017   |   2

11/12/2017   |   3

 

Quarters (year):

Q1: 01/01/2017

Q2: 01/04/2017

Q3: 01/07/2017

Q4: 01/10/2017

Q5: 31/12/2017 (mark end of year)

 

What I need to do is have a field that totals their hours in each quarter, so for instance:

 

Q1 (01/01/2017 - 31/03/2017): 15 hours

Q4 (01/10/2017 - 31/12/2017): 3 hours

 

Could anyone possibly shed some light on how to go about it?

 

Thanks in advance!

Outcomes