topic Date Time difference in hours excluding the weekends in App Development

Date Time difference in hours excluding the weekends

Deepak87 — Sat, 16 Nov 2024 18:09:21 GMT

Hi All,

I need to calculate the Date & time difference in hours excluding the weekends. i have a below expression, which provides time difference in hours. But i need to exclude the weekends as well in this.

interval(timestamp2 - timestamp1,'hh')

looking for any suggestion.

Re: Date Time difference in hours excluding the weekends

fosuzuki — Thu, 03 Sep 2020 20:07:26 GMT

Hi,

considering 2 variables:

v1 = 2020-08-21 20:00:00 (older timestamp)

v2 = 2020-08-24 21:00:00 (newer timestamp)

This expression will use the NetWorkDays function to get the working days (excluding weekends), and the second part will calculate the difference on the time part:

=interval((NetWorkDays('$(v1)', '$(v2)') - 1) + (frac('$(v2)') - frac('$(v1)')),'hh')

Re: Date Time difference in hours excluding the weekends

Deepak87 — Mon, 07 Sep 2020 08:33:35 GMT

Hi Fosuzuki,

I think your solution works when v2 is greater than v1 variable. But in my case, some times, v1 is greater than v2.

Regards,

Deepak K M