Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem with some calculation. Example:
Program Start End Stoppage in [min] Recalculated Stoppage
1 2014/01/01 22:52:53 2014/01/01 23:55:33 - -
1 2014/01/01 23:57:39 2014/01/01 23:58:02 2.10 2.10
1 2014/01/01 23:58:41 2014/01/01 23:59:10 (2014/01/01 23:59:59) 0.65 0.65 + (0.82)
1 2014/01/02 00:00:10 2014/01/02 00:02:25 1.00 1.00 - 0.82
How to calculate stoppage time to the end of day (to YYYY/MM/DD 23:59:59) and rest for next day.
Could anybody help me? (if needed, data are attached in xls. file)
Thank you
Martin
Program Start End Stoppage in [min] Recalculated Stoppage
1 2014/01/01 22:52:53 2014/01/01 23:55:33 - -
1 2014/01/01 23:57:39 2014/01/01 23:58:02 2.10 2.10
1 2014/01/01 23:58:41 2014/01/01 23:59:10 0.65 0.65 + (0.82)
(2014/01/01 23:59:59
1 2014/01/02 00:00:10 2014/01/02 00:02:25 1.00 1.00 - 0.82