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 m…

@JoseB-aws On that solution you can not get the exact working hours. How do I get working hours if you specify the hours ( from 9 till 18h for example)

Hi @Daniel15 but you can use the described logic do build your ifelse. See also [image] Calculating Time within Date Range Question & Answer You can create 2 parameters. Date Fr, Date To to allow user to input parameter values [image] Then create a calculated field u…

Hi this is how I solved the issue, taking into account working hours. You need to set up two numerical parameters workingDayEnd & workingDayStart. The logic being, (Working days - 1, Add the time from start of the end day Subtract the time from the start date) Multiply by 24 to give hours ((n…

Calculated Field for Working Hours Between

Q&A

JoseB-aws April 19, 2022, 4:39pm 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

Topic		Replies	Views
How to calculate Working Hours between 2 dates Q&A formulas , quick-sight , calculations , Business-Intelligence-Engineer	3	387	November 13, 2023
Calculating Time within Date Range Q&A analysis , filters , quick-sight , calculations , Business-Intelligence-Engineer	3	516	November 13, 2023
Date difference between two dates in hours and Minutes Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	485	April 24, 2024
Calculate the number of working days between two Control dates Q&A parameters , date , quick-sight , calculations , Business-Intelligence-Engineer	2	92	July 30, 2024
Time difference calculation Q&A date , quick-sight , calculations , Business-Intelligence-Engineer	1	344	September 6, 2024

Calculated Field for Working Hours Between

Related topics