Help

Calculate number of hours between two date/time fields, excluding weekends

Topic Labels: Formulas
176 1
cancel
Showing results for 
Search instead for 
Did you mean: 
kristinOA
4 - Data Explorer
4 - Data Explorer

Hi!

I'm trying to create a formula to calculate the number of hours between two date/time fields, excluding weekends. 

The fields are "Completion Date/Time" and "Writer Claimed Date/Time". So for one example, the Completion Date/Time field is 11/7/24 at 11:10am, and the "Writer Claimed Date/Time" is 10/31/24 at 2:59pm. Looking for the number of hours between the two, excluding weekends. 

Thanks in advance 🙂

1 Reply 1

Hey @kristinOA

I see the challenge here. Did you try to use the date formulas? Here is the process:

- Calculate the date-time difference in hours between the 2 dates. These are the total hours including weekend hours 

- Calculate the date-time difference in weeks between the 2 dates. These are the weeks between the 2 dates. Each week has one weekend which counts 48 hours right each one. 

- Calculate the difference between the 2 numbers above. Please check the screenshots below:

Dimitris_Goudis_0-1731746894741.png

Dimitris_Goudis_1-1731746907848.png

If you have further questions I would love to talk about your case with no any claim.

Thanks
 @Dimitris_Goudis 

I