Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Facing issue with the time. Need to generate the start time based on the end time and duration.
I have event end time as 00:20:00 (hh:mm:ss) and Duration as 3:20:00(hh:mm:ss).See attached qvw
Hi Gysbert,
Thanks for your reply. I need more help on this.
LoginTime | LogOutTime |
10:09:08 AM | 10:18:20 |
10:13:54 AM | 10:34:26 |
10:18:46 AM | 12:19:18 |
10:22:06 AM | 11:06:49 |
10:32:54 AM | 16:15:54 |
10:44:11 AM | 13:12:11 |
10:45:23 AM | 13:14:49 |
10:48:58 AM | 12:37:48 |
10:52:21 AM | 12:39:28 |
10:58:15 AM | 11:03:14 |
10:59:52 AM | 11:24:11 |
10:59:57 AM | 11:49:22 |
I have the LoginTime and LogoutTime need to Generate the Hours between the time in the New Column.
For Example : Taking the highlighted LoginTime and LogOut time i.e. 10:45:23 to 13:14:49 , Need to generate following hours between them i.e. 10,11,12,13 .
How can I generate new column containing Hours between the LoginTime and LogOut time ?
Regards,
Alvin.