How to generate Start Time

[alvinford]

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).

How can I get the Start Time i.e 09:00:00.

Request your help.

Thanks in Advance.

Regards,

Alvin.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw

[alvinford]

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.