Calculated Field for Working Hours Between

Question and answer
, ,
#1

I’m looking to get a calculated field that will show the working hours between two date / timestamps. Currently I have:
dateDiff({date 1} , {date 2} , ‘MI’) / 60 -

dateDiff({date 1} , {date 2} , ‘DD’) * 16 -

dateDiff({date 1} , {date 2} , ‘WK’) * 16

Is anyone able to share anything that may be more effective? Working hours to measure are from 09:00 to 17:30.

#2

Hello,
I would recommend to look at this post:
https://community.amazonquicksight.com/t/how-to-calculate-work-days/863
This will provide the working days, and you should just convert it to hours.
Br,
Jose

1 Like