Day change calculation

[mato32188]

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

[mato32188]

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