Help needed how to......

[sven ok]

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

sun 30/09 00:04    sun 30/09 01:03

sun 30/09 03:56   tue 2/10 08:45

I have no prior experience with Excel so I'm floundering badly here.

[#2]

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

[#3]

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

[#4]

---

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

[#5]

		Duration	Time
Start Time	Finish Time	(h:m)	(mins)
Wed  10/10   19:04	Fri  12/10   00:48	29:	44	228
Fri  12/10   04:36	Tue  16/10   00:13	91:	37	206
Tue  16/10   03:39	Wed  17/10   23:43	44:	04	182
Thu  18/10   02:45	Fri  19/10   11:19	32:	34	177
Fri  19/10   14:16	Sun  21/10   02:36	36:	20	178
Sun  21/10   05:34	Mon  22/10   18:18	36:	44	158

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 

[#6]

Well, the difference is simply:

FinishTime-StartTime formatted as [hh]:mm.

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