Forum Discussion
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
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.
- Detlef_LewinSilver Contributor
Is there a question hidden somewhere because you already have start and finish times.
- sven okCopper Contributor
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_LewinSilver Contributor
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.