Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ameensom
New 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
New Contributor III

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

Have you had a look hereBusiness Working Hours Calculation?

1 Reply
theglenndavid
New Contributor III

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

Have you had a look hereBusiness Working Hours Calculation?

Community Browser