Overnight calculation

[mato32188]

Hi QV fans,

if anyone knows how to use "?" to calculate records like:

Cell	Start	Finish	Start Time	Finish Time	NewDay	@NewDay	Stoppage
Cell 1	2013/08/20 23:45:08	2013/08/20 23:49:28	20.8.2013	20.8.2013	20.8.2013	0	0,38
Cell 1	2013/08/20 23:50:44	2013/08/20 23:55:05	20.8.2013	20.8.2013	20.8.2013	0	1,27
Cell 1	2013/08/21 00:21:22	2013/08/21 00:25:08	21.8.2013	21.8.2013	20.8.2013	1	26,28

Stoppage [min] is calculated as difference between last Finish and next Start. Could anybody help, how to calculate Stoppage till 23:59:59 and rest of stoppage time add to next record?...Thanks a lot

Martin

[tresesco]

Could you elaborate a bit more(would be better if with an expected output example)?

[mato32188]

Cell	Start	Finish	Start Time	Finish Time	NewDay	@NewDay	Expected Stoppage [min]
Cell 1	2013/08/20 23:45:08	2013/08/20 23:49:28	20.8.2013	20.8.2013	20.8.2013	0	X
Cell 1	2013/08/20 23:50:44	2013/08/20 23:55:05	20.8.2013	20.8.2013	20.8.2013	0	(20.8.2013 23:59:59-20.8.2013 23:55:05)
Cell 1	2013/08/21 00:21:22	2013/08/21 00:25:08	21.8.2013	21.8.2013	20.8.2013	1	21.8.2013 00:21:21 - 20.8.2013 00:00:00)

[arjunkrishnan]

Hellow  Frd See This Sample  Qvw.File ...

I Try This One...I hope u to Useful for U..

My Result Like That

Thank U By

Arjun Krish

[tresesco]

Do you mean, for the first record, you would want the start timestamp to consider as ...23:59:59 and rest are as it is?

[mato32188 · Accepted solution]

I mean, if the stoppage goes thru the midnight, add aliquot stoppage time till the end of day (to 23:59:59) and if there is a rest of stoppage time, add it to next record.

Thanks