ebrazeau13
New Member
- Joined
- Aug 14, 2017
- Messages
- 6
Looking to find a formula that will help me find the exact amount of time that falls within a given range. Here is my situation:
I have been tasked to find the amount of time that falls within an "Operational time". The range of this operational time is between 06:00:00 and 22:00:00. Here is an example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Total Time[/TD]
[TD]Operational Time[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:50:00[/TD]
[TD]08:00:00[/TD]
[TD]430[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]06:05:00[/TD]
[TD]08:15:00[/TD]
[TD]130[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]07:40:00[/TD]
[TD]15:20:00[/TD]
[TD]460[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08:00:00[/TD]
[TD]15:35:00[/TD]
[TD]455[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08:25:00[/TD]
[TD]23:30:00[/TD]
[TD]905[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08:25:00[/TD]
[TD]22:25:00[/TD]
[TD]840[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08:40:00[/TD]
[TD]23:55:00[/TD]
[TD]915[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there a formula that I am able to use that will figure out the amount of time that falls between 06:00:00 and 22:00:00?
I have been tasked to find the amount of time that falls within an "Operational time". The range of this operational time is between 06:00:00 and 22:00:00. Here is an example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Total Time[/TD]
[TD]Operational Time[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]00:50:00[/TD]
[TD]08:00:00[/TD]
[TD]430[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]06:05:00[/TD]
[TD]08:15:00[/TD]
[TD]130[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]07:40:00[/TD]
[TD]15:20:00[/TD]
[TD]460[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08:00:00[/TD]
[TD]15:35:00[/TD]
[TD]455[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08:25:00[/TD]
[TD]23:30:00[/TD]
[TD]905[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08:25:00[/TD]
[TD]22:25:00[/TD]
[TD]840[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]08:40:00[/TD]
[TD]23:55:00[/TD]
[TD]915[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Is there a formula that I am able to use that will figure out the amount of time that falls between 06:00:00 and 22:00:00?