Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshm030
Creator III
Creator III

Split the time one hour to one hour

Hi All,

I have a data given below screenshot.

dineshm030_0-1625041246933.png

IDStartDateUTCEndDateUTCIPAddressReasonCode
95634D78-64CE-43B3-B430-0926A9DEDEA507-06-2021 15:2707-06-2021 20:2810.22.33.70112

 

The requirement is have to take time difference between StartDate and EndDate field. The overall time diff is 5:0:10. 

I have to split the data like this:

StartTimeEndTimeDowntime in Mins
00:0001:000
01:0002:000
02:0003:000
03:0004:000
04:0005:000
05:0006:000
06:0007:000
07:0008:000
08:0009:000
09:0010:000
10:0011:000
11:0012:000
12:0013:000
13:0014:000
14:0015:000
15:0016:0033
16:0017:0060
17:0018:0060
18:0019:0060
19:0020:0060
20:0021:0032
21:0022:000
22:0023:000
23:0000:000

 

Thanks in advance. @MayilVahanan  @sunny_talwar   @marcus_sommer 

Regards,

Dinesh.

Labels (2)
0 Replies