Forum Discussion

sven ok's avatar
sven ok
Copper Contributor
Oct 13, 2018

Help needed how to......

I need help building a formula to work out start times and finish times. The start time is 6am and the finish time is 6am (24hr) START:                  Finish sat 29/09 23:03     sun 30/09 00:03 ...
excel
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Oct 13, 2018

Is there a question hidden somewhere because you already have start and finish times.

 

sven ok's avatar
sven ok
Copper Contributor
Oct 13, 2018

I hear what you’re saying.

 

But start time is 6 am finish time is 6 am. It could be three days it could be over 2.5 days.

All I receive is total hours I need to break it down from 6 to 6

 

I understand 6 am to 6 am is 24, but I don’t receive this. I receive

 

Sat  29/09   23:03

Sun  30/09   00:03

Sun  30/09   00:03

Sun  30/09   01:03

Sun  30/09   01:03

Sun  30/09   02:03

Sun  30/09   02:03

Mon  01/10   10:55

Mon  01/10   13:28

Wed  03/10   07:35

Wed  03/10   10:32

Thu  04/10   03:05

Thu  04/10   06:07

Sun  07/10   05:30

Sun  07/10   05:30

Mon  08/10   19:30

Mon  08/10   19:30

Wed  10/10   16:07

Wed  10/10   19:04

Fri  12/10   00:48

Fri  12/10   04:36

Mon  15/10   03:08

Mon  15/10   06:34

Tue  16/10   16:30

Tue  16/10   19:32

Wed  17/10   20:36

Wed  17/10   23:33

Fri  19/10   03:32

Fri  19/10   06:30

Sat  20/10   10:47

Sat  20/10   13:25

Sun  21/10   23:04

Mon  22/10   01:47

Tue  23/10   03:29

Tue  23/10   06:57

Wed  24/10   13:02

Wed  24/10   16:18

Fri  26/10   01:33

Fri  26/10   05:52

Sun  28/10   05:30

Sun  28/10   05:30

Mon  29/10   19:30

 

I then have to work out the individual run

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Oct 14, 2018
    sven ok wrote:

    All I receive is total hours I need to break it down from 6 to 6 

    I can't see total hours in your list, just start and finish times.

    And what do you mean by "break it down from 6 to 6"?

     

    Please show your desired results.

     

    • sven ok's avatar
      sven ok
      Copper Contributor
      Oct 14, 2018
        DurationTime
      Start TimeFinish Time(h:m)(mins)
      Wed  10/10   19:04Fri  12/10   00:4829:44228
      Fri  12/10   04:36Tue  16/10   00:1391:37206
      Tue  16/10   03:39Wed  17/10   23:4344:04182
      Thu  18/10   02:45Fri  19/10   11:1932:34177
      Fri  19/10   14:16Sun  21/10   02:3636:20178
      Sun  21/10   05:34Mon  22/10   18:1836:44158

       

      How I understand it: start time wed 19:04. However the count doesn't start until 6am
      the run finishes on friday 6am =24hrs
      the left over hours will be classed as down time

       

      Start time Friday 04:36- so I count from 6am and then Finish time is 6am Monday 

       

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Oct 14, 2018

        Well, the difference is simply:

        FinishTime-StartTime formatted as [hh]:mm.

        But I have no idea how to get 228, 206, etc.

         

Resources