Skip to main content

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 🙂

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:

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

Thanks
 @Dimitris_Goudis 

I

Reply


Terms & Conditions