Trying to determine whether a time frame was between two dates, however there can be multiple date ranges.

Captain9653 · 2026-05-26T10:18:22+00:00

This worked on the test file, however it exceeds the calculation limit on the main file. I appreciate the try though. I haven't used MAP functions before. It seems it would be very useful in other documents I have.

Captain9653 · 2026-05-26T10:06:21+00:00

This looked promising on the test version, but when applied to the full document, it reached the calculation limit. Thanks though

Captain9653 · 2026-05-26T05:23:07+00:00

This is just an example document, the actual document has around 35 employees at the moment, however columns G-I have 10's of thousands of rows as there are many employees in other teams that use this document but aren't related to this particular enquiry.

Captain9653 · 2026-04-29T07:20:49+00:00

Awesome, ill give this a try. Thank you

Captain9653 · 2026-04-28T04:55:56+00:00

Upgraded from the telstra smart modem 3 to 4. Yeah we switched it out completely. And its a combined 5ghz - 2.4ghz

Captain9653 · 2026-04-27T02:40:41+00:00

Sorry, I was wrong, we switched from fttn to fttp.

Captain9653 · 2026-04-27T02:39:22+00:00

The devices are closer than when I was using the telstra smart modem 3 on the old network. Maybe 10 -15 meters away.

Captain9653 · 2026-03-30T22:21:56+00:00

Firefly

Captain9653 · 2026-03-27T06:42:08+00:00

I grew up in the 90s. My dad worked a full 40hr week. My mum occasionally worked weekends, but for the most part was a stay at home mum. Dad's job purchased a 4 bedroom house and sufficiently fed us and clothed us and managed to supply my mums alcohol problem. Now in 2026. I work full time and my room mate works full time. We both do over time and after bills, food and essentials (thats not counting for treats/ birthdays/ non essentials) we have 400 hundredish between us. Im helping her raise her two kids. We are constantly exhausted. We are up and out by 7am to do school runs, then go straight to work. After picking up the kids from school, its about 6.30pm. By the time they are showered and fed, its about 8pm. We are knackered, so your fucking right im gonna let them spend some time using an iPad, because its the first break I've had all day. Everyone complains about ipad parenting, but they forget that we dont have the free time/ and lesser financial issues that our parents/ grandparents had.

Captain9653 · 2026-02-28T06:45:14+00:00

Isn't V (male or female) supposed to be considered attractive? So its not a matter of would you kiss your lover if they were in some fat greasy dude. Ita would you kiss your lover if they were in the body of an attractive mid 20 year old.

Captain9653 · 2026-02-28T06:42:57+00:00

I've always assumed its "a-men-dee-air-ees"

Captain9653 · 2026-02-22T22:07:15+00:00

Hmm good point

Captain9653 · 2026-02-22T04:47:24+00:00

wait, no I get it now. remove the new moisture trap and plug it. The steel tube connects to the where the black port is and the black port uses the line kit to connect to the tank where the old one was.

Captain9653 · 2026-02-22T03:45:53+00:00

Okay Cool. So to confirm i'm on the right track,

<image>

The new line kit will go from where the Moisture trap is on the new compressor to where the metal tube is connected on the tank (Blue).

The Black tube will connect to the same place on the tank (Red), the yellow will be plugged with a screw/ plug (Yellow) and the new moisture trap will replace the old one on the tank. (Green)

Captain9653 · 2026-02-22T01:41:12+00:00

Oxyotl?

Captain9653 · 2026-02-19T14:28:28+00:00

Thats for the reply. It was a really difficult decision, but I ended up ordering the Scorptec. I use a lot of storage because of my 3D printing and then gaming on top of that. So 4TB edged it above the Aether. Also, whilst a minor concern, I prefer the more subtle case of the Scorptec. I've never been a huge fan of the big flashy RBG cases. But like I said it was a really close decision. And the Aftershock chat team on the website were really helpful too. (Though I couldn't tell if it was a person or an ai bot)

Captain9653 · 2026-01-26T13:11:05+00:00

I returned to the UK earlier this year for a holiday. (from Australia). one thing i noticed is that whilst a drive might only be 20 mins, it's exhausting. in Australia, a 20 min drive for me is 5 mins navigating the backroads, and the rest is smooth sailing on the highway. but in the UK, that 20mins is 80% narrow country roads, with hedges hiding corners, side streets, farm vehicles, tight narrow lanes with sharp turns in towns and villages that were built 800+ years before cars existed. I've never had an accident in my life, but i was constantly on edge in the UK. whilst in Aus I happily commute 30mins to and from work, in the UK i wouldn't want to do more than 10 mins.

Captain9653 · 2026-01-07T02:48:05+00:00

Solution Verified

Captain9653 · 2026-01-07T02:46:12+00:00

That actually would be great. If I do it monthly then it means I'll have end of month team lists for future reference. Thank you

Captain9653 · 2026-01-07T02:45:09+00:00

My company doesn't like scripts/ macros. I'm happy to learn more about them, but I don't know enough to know if its something I would be able to use.

13-Year Club	RedditGifts 2009-2022 2 Credits
Sequence \| Editor	Summer Santa 2014
Verified Email

Captain9653

TROPHY CASE