Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ameensom
Contributor II
Contributor II

How to calculate different between two time,date fields and eliminate at the same time

Hi, I hope someone can help me on this!

I have created a new table like this

New Field.jpg

I have two fields

  1. createdAt (represents when a request is created)
  2. DispatchedOn (represents when a request has been dispatched)

What I want:

  1. I want to first calculate minutes between creation time, and dispatching time
  2. I want to eliminate the hours and the days we do not work

We only open from 8:00 am, to 18:00 pm and we don't work on Fridays

I would appreciate the answers to the two points I need to do,

1 Solution

Accepted Solutions
theglenndavid
Partner - Contributor III
Partner - Contributor III

1 Reply
theglenndavid
Partner - Contributor III
Partner - Contributor III

Have you had a look hereBusiness Working Hours Calculation?