Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Mahamed_Qlik
Specialist
Specialist

No of days from decimal values

HI

I have start_time and End_time as below:
I want to create one column to show no.of hours between start_time and end_Time:

 

 

Start_Time

End_Time

730

1430
830 1530
800 900
900 1600

 

Expected column:

 

Start_Time

End_Time Hours

730

1430 7
830 1130 3
800 900 1
900 1700 8

 

Kindly help

 

Regards,

Mahamed

Labels (1)
0 Replies