Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Highlighted
Nikhith
New Contributor

How to Calculate hours between two dates

How to Calculate hours between two dates

Ex:

two dates in my excel

opendate is : Mon 18/11/2018 11:30 AM

closedate : Mon 18/11/2018 11:50 AM

1st_shift : 00:00 to 08:59

2nd_shift: 09:00 to 17:59

3rd_shift: 18:00 to 11:59

 

open date time in 1st_shift calculate time in 1st_shift only


Ex:

opendate is : Mon 18/11/2018 08:50 AM

closedate : Mon 19/11/2018 00:10 AM

Result: 30 Min

Ex2:

opendate is : Mon 18/11/2018 17:50

closedate : Mon 19/11/2018 09:10 AM

Result: 20 Min


any one please help me.

Regards

Nikhith

1 Reply

Re: How to Calculate hours between two dates

Community Browser