Formula Help with overlapping times

Y

yessir

Board Regular
Joined
Jun 7, 2019
Messages
103
Office Version
  1. 2021
Platform
  1. MacOS
I am trying to find a formula that would help me find how many cars overlap and are in the lot at the same time but only when column D is False. I would then want to count how many cars are in the lot at the same time. The start times are located in B2:B7 and end times are in C2:C7. I've tried using a SUMPRODUCT function but was wondering if there was an easier way to go about this and include the function to count the number of cars that overlap.
A B C D
[TABLE="width: 567"]
<tbody>[TR]
[TD]Arvl Lot Location[/TD]
[TD] Arvl Time[/TD]
[TD] Dept Time[/TD]
[TD]Is Overnight[/TD]
[/TR]
[TR]
[TD]xxx[/TD]
[TD]15:25[/TD]
[TD]16:10[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]xxx[/TD]
[TD]21:10[/TD]
[TD]22:15[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]xxx[/TD]
[TD]8:21[/TD]
[TD]9:19[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]xxx[/TD]
[TD]11:08[/TD]
[TD]11:45[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]xxx[/TD]
[TD]14:29[/TD]
[TD]15:15[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]xxx[/TD]
[TD]19:55[/TD]
[TD]21:20[/TD]
[TD]FALSE[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited by a moderator:
Sort by date Sort by votes
yessir said:
The negative numbers are gone, thanks. However, I don't quite understand the formula and what exactly the numbers that they calculate mean. Because the numbers seem to be much higher than the actual number of cars overlapping
Click to expand...

An example

Row 3

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]
A​
[/TD]
[TD="bgcolor: #DCE6F1"]
B​
[/TD]
[TD="bgcolor: #DCE6F1"]
C​
[/TD]
[TD="bgcolor: #DCE6F1"]
D​
[/TD]
[TD="bgcolor: #DCE6F1"]
E​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]
3​
[/TD]
[TD]zzz[/TD]
[TD]
19:35​
[/TD]
[TD]
20:36​
[/TD]
[TD]
FALSE
​
[/TD]
[TD]
5​
[/TD]
[/TR]
</tbody>[/TABLE]

Why 5 in E3?
Because it overlaps with

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]
A​
[/TD]
[TD="bgcolor: #DCE6F1"]
B​
[/TD]
[TD="bgcolor: #DCE6F1"]
C​
[/TD]
[TD="bgcolor: #DCE6F1"]
D​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]
12​
[/TD]
[TD]
zzz​
[/TD]
[TD="bgcolor: #FFFF00"]
19:00​
[/TD]
[TD="bgcolor: #FFFF00"]
20:00​
[/TD]
[TD]
FALSE​
[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]
A​
[/TD]
[TD="bgcolor: #DCE6F1"]
B​
[/TD]
[TD="bgcolor: #DCE6F1"]
C​
[/TD]
[TD="bgcolor: #DCE6F1"]
D​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]
16​
[/TD]
[TD]
zzz​
[/TD]
[TD="bgcolor: #FFFF00"]
19:11​
[/TD]
[TD="bgcolor: #FFFF00"]
20:49​
[/TD]
[TD]
FALSE​
[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]
A​
[/TD]
[TD="bgcolor: #DCE6F1"]
B​
[/TD]
[TD="bgcolor: #DCE6F1"]
C​
[/TD]
[TD="bgcolor: #DCE6F1"]
D​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]
26​
[/TD]
[TD]
zzz​
[/TD]
[TD="bgcolor: #FFFF00"]
19:39​
[/TD]
[TD="bgcolor: #FFFF00"]
20:26​
[/TD]
[TD]
FALSE​
[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]
A​
[/TD]
[TD="bgcolor: #DCE6F1"]
B​
[/TD]
[TD="bgcolor: #DCE6F1"]
C​
[/TD]
[TD="bgcolor: #DCE6F1"]
D​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]
32​
[/TD]
[TD]zzz[/TD]
[TD="bgcolor: #FFFF00"]
19:17​
[/TD]
[TD="bgcolor: #FFFF00"]
20:49​
[/TD]
[TD]
FALSE​
[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]
A​
[/TD]
[TD="bgcolor: #DCE6F1"]
B​
[/TD]
[TD="bgcolor: #DCE6F1"]
C​
[/TD]
[TD="bgcolor: #DCE6F1"]
D​
[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]
42​
[/TD]
[TD]
zzz​
[/TD]
[TD="bgcolor: #FFFF00"]
18:53​
[/TD]
[TD="bgcolor: #FFFF00"]
20:40​
[/TD]
[TD]
FALSE​
[/TD]
[/TR]
</tbody>[/TABLE]


M.
 
Last edited by a moderator:
Upvote 0

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Thank you. Is there a function that would be able to sum up the numbers in column E but only for when colomn A are the same. Therefor it would know to start counting column E from Zero again when Column A changes. Thanks for your help.
 
Last edited by a moderator:
Upvote 0
Try SUMIF

For example
=SUMIF(A:A,"zzz",E:E)

M.
 
Last edited by a moderator:
Upvote 0
I've given it a shot and it seems to only work for zzz but not when Column A has a different Code.
 
Last edited by a moderator:
Upvote 0
Is there a way to omit the numbers until the last cell, so it only returns one value at the bottom.

[TABLE="width: 464"]
<tbody>[TR]
[TD="width: 122"]Column1[/TD]
[TD="width: 123"]Column2[/TD]
[TD="width: 139"]Column3[/TD]
[TD="width: 82"]Column4[/TD]
[TD="width: 76"]Column5[/TD]
[TD="width: 76"]Column6[/TD]
[/TR]
[TR]
[TD]qqq[/TD]
[TD]6:15[/TD]
[TD]7:15[/TD]
[TD]FALSE[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]qqq[/TD]
[TD="bgcolor: transparent"]18:06[/TD]
[TD="bgcolor: transparent"]19:06[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD]qqq[/TD]
[TD]21:40[/TD]
[TD]22:44[/TD]
[TD]FALSE[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]qqq[/TD]
[TD="bgcolor: transparent"]11:40[/TD]
[TD="bgcolor: transparent"]13:05[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[/TR]
[TR]
[TD]qqq[/TD]
[TD]14:07[/TD]
[TD]14:57[/TD]
[TD]FALSE[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]qqq[/TD]
[TD="bgcolor: transparent"]7:12[/TD]
[TD="bgcolor: transparent"]8:50[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: right"]2[/TD]
[TD="bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD]qqq[/TD]
[TD]9:39[/TD]
[TD]10:52[/TD]
[TD]FALSE[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]qqq[/TD]
[TD="bgcolor: transparent"]17:13[/TD]
[TD="bgcolor: transparent"]18:00[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]8[/TD]
[/TR]
[TR]
[TD]qqq[/TD]
[TD]8:46[/TD]
[TD]9:45[/TD]
[TD]FALSE[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]qqq[/TD]
[TD="bgcolor: transparent"]20:10[/TD]
[TD="bgcolor: transparent"]21:10[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]13[/TD]
[/TR]
[TR]
[TD]qqq[/TD]
[TD]9:10[/TD]
[TD]10:25[/TD]
[TD]FALSE[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]qqq[/TD]
[TD="bgcolor: transparent"]19:32[/TD]
[TD="bgcolor: transparent"]20:35[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: right"]1[/TD]
[TD="bgcolor: transparent, align: right"]17[/TD]
[/TR]
[TR]
[TD]qqq[/TD]
[TD]21:54[/TD]
[TD]22:47[/TD]
[TD]FALSE[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]18[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]qqq[/TD]
[TD="bgcolor: transparent"]9:28[/TD]
[TD="bgcolor: transparent"]10:34[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: right"]3[/TD]
[TD="bgcolor: transparent, align: right"]21[/TD]
[/TR]
[TR]
[TD]qqq[/TD]
[TD]12:37[/TD]
[TD]13:17[/TD]
[TD]FALSE[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]22[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]qqq[/TD]
[TD="bgcolor: transparent"]16:22[/TD]
[TD="bgcolor: transparent"]17:05[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: right"]0[/TD]
[TD="bgcolor: transparent, align: right"]22[/TD]
[/TR]
</tbody>[/TABLE]

For example, we would only see the 22 in the last row an not the numbers above it.
 
Last edited by a moderator:
Upvote 0
yessir said:
Thank you. Is there a function that would be able to sum up the numbers in column E but only for when colomn A are the same. Therefor it would know to start counting column E from Zero again when Column A changes. Thanks for your help.
Click to expand...

You can create a pivot table, where the row label is the information from column A and the value is the sum of column E
 
Upvote 0
that formula works. Thanks.

For a different format of the data that im working on i've been using this formula =SUMPRODUCT((B2<=$C$2:$C$45)*(C2>=$B$2:$B$45))>1 I used this formula to simply return a TRUE or FALSE Statement. Where the TRUE value indicates if it overlaps with any other cars in the lot. I was wondering if you could help me figure out how to edit this formula where when column A changes the formula knows to restart and look for overlaps in times at a different location (similar to what we did eailer). Below is the data where Column D represents if it is there overnight and Column E represents if it overlaps with another time.

[TABLE="width: 430"]
<tbody>[TR]
[TD="width: 122"] Arvl Sta
A[/TD]
[TD="width: 123"] Arvl Time
B[/TD]
[TD="width: 139"] Dept Time
C[/TD]
[TD="width: 97"]Is Overnight
D[/TD]
[TD="width: 92"]Does Ovlap
E[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]21:47[/TD]
[TD]8:43[/TD]
[TD]TRUE[/TD]
[TD="align: center"]FALSE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]19:35[/TD]
[TD="bgcolor: transparent"]20:36[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]11:01[/TD]
[TD]11:56[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]14:29[/TD]
[TD="bgcolor: transparent"]15:24[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]17:15[/TD]
[TD]18:04[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]21:00[/TD]
[TD="bgcolor: transparent"]22:14[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]12:35[/TD]
[TD]13:20[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]15:23[/TD]
[TD="bgcolor: transparent"]16:10[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]6:44[/TD]
[TD]7:34[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]13:30[/TD]
[TD="bgcolor: transparent"]14:15[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]19:00[/TD]
[TD]20:00[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]16:17[/TD]
[TD="bgcolor: transparent"]16:57[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]7:38[/TD]
[TD]8:45[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]11:36[/TD]
[TD="bgcolor: transparent"]12:34[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]19:11[/TD]
[TD]20:49[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]9:17[/TD]
[TD="bgcolor: transparent"]10:19[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]16:04[/TD]
[TD]16:59[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]17:41[/TD]
[TD="bgcolor: transparent"]18:52[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]6:11[/TD]
[TD]7:09[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]14:50[/TD]
[TD="bgcolor: transparent"]15:40[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]14:47[/TD]
[TD]15:42[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]20:50[/TD]
[TD="bgcolor: transparent"]22:25[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]13:49[/TD]
[TD]14:34[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]16:43[/TD]
[TD="bgcolor: transparent"]17:29[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]19:39[/TD]
[TD]20:26[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]11:59[/TD]
[TD="bgcolor: transparent"]13:00[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]9:00[/TD]
[TD]9:40[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]11:30[/TD]
[TD="bgcolor: transparent"]12:50[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]8:57[/TD]
[TD]9:37[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]22:25[/TD]
[TD="bgcolor: transparent"]6:30[/TD]
[TD="bgcolor: transparent"]TRUE[/TD]
[TD="bgcolor: transparent, align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]19:17[/TD]
[TD]20:49[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]20:44[/TD]
[TD="bgcolor: transparent"]21:46[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]15:54[/TD]
[TD]17:08[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]14:50[/TD]
[TD="bgcolor: transparent"]15:52[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]14:20[/TD]
[TD]15:30[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]18:13[/TD]
[TD="bgcolor: transparent"]19:00[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]15:44[/TD]
[TD]17:00[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]16:59[/TD]
[TD="bgcolor: transparent"]18:15[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]11:23[/TD]
[TD]12:30[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]10:00[/TD]
[TD="bgcolor: transparent"]11:05[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]18:53[/TD]
[TD]20:40[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]19:53[/TD]
[TD="bgcolor: transparent"]9:00[/TD]
[TD="bgcolor: transparent"]TRUE[/TD]
[TD="bgcolor: transparent, align: center"]FALSE[/TD]
[/TR]
[TR]
[TD]zzz[/TD]
[TD]8:45[/TD]
[TD]10:10[/TD]
[TD]FALSE[/TD]
[TD="align: center"]TRUE[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]zzz[/TD]
[TD="bgcolor: transparent"]12:10[/TD]
[TD="bgcolor: transparent"]13:25[/TD]
[TD="bgcolor: transparent"]FALSE[/TD]
[TD="bgcolor: transparent, align: center"]TRUE[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited by a moderator:
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Count entry by time
Replies
3
Views
194
admvlad
A
J
  • Question Question
How to Find Time Overlaps
2
Replies
10
Views
762
JK_NMS
J
S
  • Question Question
Using VBA to Flag and Calculate Overlapping Shift Times
Replies
0
Views
464
Snort
S
ibmy
  • Question Question
How to structure the formula properly?
Replies
2
Views
243
ibmy
ibmy
M
  • Solved
How to merge files?
Replies
2
Views
385
mrdigitalis
M

Forum statistics

Threads
1,223,905
Messages
6,175,297
Members
452,633
Latest member
DougMo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top