u/Alternative-Day5268

Hi All,

I have a SharePoint list. Within it I have two Columns, Start Date and End Date. They have a time on them also.

I need a third column that calculates the number of working hours between the two dates.

Working hours are 9am til 5.30pm, it should also exclude a list of bank holidays which I have another list for, and exclude weekends. Also if End date is currently empty can it calculate the time between start time and NOW.

I.e.

Start date is 4.30pm 12/08/2026

End date is 09.30 am 13/08/2026

Duration is 1:00 ( [h]:mm )

Is there a way I can get power automate to figure this out and then have that info show in the column?

Hi guys, so age old problem of Dog Vs Cat.

Since as long as I can remember my dog (now about 5 YO springer whippet cross, male) is demented by cats. If he sees one on a walk or out the window he's goes wild, barking, scratching the window, running about the house. I don't think it's just a prey/excitement thing, it appears to cause him actual stress/anxiety.

This used to be manageable in our old house, he could only ever really see a cat on a night from our bedroom window, we could remove him for 10 minutes and bring him back in the room (the cats gone and after looking out the window again for a bit he would settle).

But our new house there's about 3 cats who live very close. So they're in front of the house, in the back gardens. So the only time he would never really be able to see one is in the kitchen/hallway/staircase/landing. Which is the space he has while we are out of the house.

But it's becoming so much more frequent, he will scratch at the fence when next doors cat is outside.

So it's hard for us to just avoid cats entirely. He likes to look out of the window a lot. When he barks we have tried, a click where he will come to us, and after a pause give a high-value treat. We've tried removing immediately and some crate time.

I'm not really sure what else to try. Even de-sensitising him to cats would be dangerous for the cat (and for him) as he would be unpredictable.

I'm not really sure where this hatred comes from, if it's just his instinct or if he's had a bad interaction with one while we haven't been with him.

Any ideas on the best approach so we can build a consistent plan/routine with him when he sees a cat?

This post contains content not supported on old Reddit. Click here to view the full post

Hi guys,

I want to preface this by saying I'm not a \*huge\* movie buff. I was more into reading media properly maybe 10 years ago. I watched some of Nolan's stuff like Inception and The Dark Knight. But I just wanted to get some thoughts off about the Odyssey and get some actual feedback on them, to help me understand my feelings on the film a bit better.

My initial takeaways are:

Pros:

\- Amazing practical effects

\- I really liked the body horror, the way the Cyclops makes you actually recoil and makes you feel a bit ill just by looking at it. Similarly Circes scene where she is physically manipulating the men into pigs was fantastic.

\- The cinematography, especially in Hades - the scene was poetically dark and ominous, matching the realisation of Odysseus of the impact of his actions. It was haunting.

\- The siege of Troy - I like how Odysseus isn't really portrayed as a 'hero' of sorts. He's smart and skilled but he led his men to rape and pillage in campaigns and left a trail of bodies behind him. I loved the entrance of Agamenon. It feels a little bit Dark Knight/Darth Vader but I do like how he shrouded in mystery.

Negatives

\- My gut reaction when the film ended was kind of - did I enjoy that? I just felt something was missing. I felt like I should be the target audience. Love history, love mythology, like long epic films. What was I expecting? An action flick?

\- Maybe the film jumps about a little bit? It took me awhile to kind of settle into the film - I've seen some people say this was intentional to make you 'feel' like you're on the odyssey. I kind of feel like some of the plot points take a very long time to establish - the starting Ithaca scenes almost make it feel like they're blue-balling you to see the legendary Odysseus (perhaps intentional?). There's parts where Penelope and Telemachus are talking about whether she should marry or not. To me it sounds like Penelope wanted (reluctantly) to re-marry because she promised Odysseus, but then in other dialogue it doesn't sound that way?

\- some of the Islands felt like they were there for a very short time. Particularly the laestrygonions. But I understand the time constraints.

\- in the same breath some parts went on a verykng time, like the return to Ithaca, which, if I'm honest just felt like they were teasing the shot of the 12 axes.

\- I also wanted to really like Rob Pattz performance - he's so snob and proud, his family failed to live up to their promises. But when he's hiding behind the pillar should to get weapons, something just felt off about this and it happened a few times. I also don't understand if he was meant to be more emotionally clever (stopped the others killing the dog and things escalating at times, not volunteering to shoot the bow), but just don't feel it was very fleshed out?

As a side note, knowing the story of Odysseus, I honestly thought the first Ithaca scene was going to link to the last scenes. I thought one of the first beggars was going to be Odysseus and do a grand reveal 'I've been here for months'. This idea was compounded when Dead Agamenon tells Odysseus to watch and wait and take his time. I know they had to ramp the tension up for the lasts scene and make it 'imminent'. But I don't really think Odysseus took his time other than observing the others 'from below' for a day or so.

I'm really trying to articulate myself well because I think the film deserves a good articulation for me to say I'm a bit underwhelmed by it.

Maybe it's my fault and I just didn't 'get' the film. Maybe I didn't get all of the emotional stuff 100% of the time or link the dots early enough to get the pay offs? Maybe I \*did\* expect something a bit more actiony. I can recognise the film is technically very stunning and they've obviously given a lot of thought about this recreation of Odysseus and what his story means to a modern audience.

Did anyone else feel like this or give me feedback on my thoughts - I feel genuinely bummed for not being able to say 'i really enjoyed it'.

For context I'm currently levelling some characters. I have a lvl 90 vengeance DH, with 280ish I lvl, a fresh lvl 90 BM hunter, and a 81 disc priest, and a 81 prot pally. I'm just levelling a few up mainly for the option of some variety but also to see what I enjoy playing.

I've been levelling my disc priest through time walking. The healing rotation seems a little unorthodox and I can't get a good idea of if I'm doing a good job. Most of the time the tanks have the top healing. I assume this is due to their leech or their own healing abilities.

I start off with the aoe heal to slap atonement on everyone and then go to my damage rotation. Which seems fine. But when the tank is fall I lay shield and flash heals but they don't seem very effective.

Is this because my gear is under levelled to what it should be for my level and the scaling is skewed?

I've just done the catch up tutorial to get me up to 80 i-lvl but this seems quite low to start midnight content to lvl.

I kinda wanted a healing spec on stand by but might just spec to shadow because I do mainly solo content with some heroics or time walking mixed in.

So I just want to check:

Does my rotation sound ok, is the scaling just off because of Timewalking. And what's the best way to get decent gear for 80+ and when I hit 90?

Also do disc priests have no interior and is it better to swap to shadow for solo stuff due to this?

Hi all,

On midnight and just want to make sure I understand a few things. I recently upgraded my adventurer cloak to 6/6, then through some content (can't remember) I got a purple heroic or veteran cloak.

So my question is, am I best saving my crests for when I am struggling with the current content I am doing? How do I know i won't get a better piece of gear?

Also if I have say and adventurer piece of kit, maxed out, but I get a veteran piece, which has a lower I level now, I'm best of keeping the veteran piece for when I can upgrade it to a better i-lvl?

I am mainly doing delves. Currently tier 5-6, and some world quests. Tried the rituals and the void strike stuff too and ventured into Naigtal (not really sure what I get from being there), and doing heroics

I don't have the time to raid, I might do some mythic+(+?) at some stage.

Also I understand my currency will be wiped at the start of the new season. So whatever my crests are before the wipe it's best to just spend it all?

Hi, coming back from classic just for a change of pace for a bit. Remembered the reason I went back to classic. It's kind of overwhelming all the content, the currencies, vendors etc. I understand I want to be checking stuff off every week for the great vaults for better gear but have some questions.

Is there an overview somewhere or all the currencies and how they are used?

So for the bottom great vault requirement I can do delves or world quests, can I just run 8 delves or should I be doing world quests too, I assume they have some reps or something I can increase?

Should I just focus on checking off my great vault list in order of the content I prefer doing?

Havoc DH init makes a difference.

Hi so at the moment I'm mainly playing classic hardcore. But I also want a game mode where I can just pick up and play a bit without having to do really much of anything, just hop on for 10 minutes.

I like the *idea* of solo shuffle and doing a few matches when I only have 20-30 mins. Although I like the idea of it I've done much PvP since original tbc arena. And everything just looks so fast paced now. I know people are playing rotations for burst damage but it looks like button mashing. I'm considering BM hunter or Ret pally.

Is there anything you can say to persuade me it might be fun and worth learning PvP or any tips. Another stickler is that I play on steam deck, which I am proficient with, I think more than most and be comfortable with many keybinds.

Hi guys,

​

Hit 60 on my TBC pala and don't think I had it in me to grind it out to 70.

​

So I decided Id give hardcore a go. One of the things I'm worried about is that my main does and I really don't think I could re-level from scratch with nothing else to show.

​

Kinda came up with my own challenge. I have 5 characters with all unique proffessions/classes. And I have to level them up together (i.e. get them all to lvl 10, then level them in 5 level blocks.

​

I think it will help me slow down a bit. And if one character dies I've still got decent progress somewhere. I've mocked up my plan below. I'm not sure whether to swap the hunter and rogue's proffessions as I suppose using bombs that require eng skill will be more useful to a rogue - and I'm trying to keep the proffessions broadly thematic to the class.

Race	Class	Spec	Proff 1	Proff 2
Dwarf	Hunter	Beast Master	Mining	Engineering
Human	Paladin	Protection	Herbalism	Alchemy
Human	Rogue		Skinning	Leatherworking
Dwarf	Warrior		Mining	Blacksmithing
Gnome	Warlock		Tailoring	Enchanting

Any hints/tips/feedback. I've played on and off since vanilla, and as I'm much more casual now I notice as I get to max level (I'm not bothered about end game) I kinda of get bored, so figured this would be a great way to learn some new classes, new proffessions, keep the game interesting. And naturally, with them having all proffessions and levelling gradually I can share some decent gear amongst them that I won't have seen before.

Edit: also it says protection for the paladin, I've just levelled a Ret pal on tbc so wanted something fresh that wasn't holy spec

Just been running some scarlet monastery and our tank had said he didn't know the way in SM cath. Made me think he's either retail or freshly new to wow.

Turns out he's brand new and never played before. The run wasn't perfect, but I've had worse. It was so refreshing have a tank that was new and us showing him how the mechanics and to pull outside of the cathedral etc. also after asking the mage for water a few times he asked if that was a specific mage skill. I just really appreciated the freshness of a new player being a bit naive and discovering the game.

I know there's some bad apples in the community but not only was this guy new to the game but actually tanking and taking on feedback. Love the game is still getting new players

This post contains content not supported on old Reddit. Click here to view the full post

This post contains content not supported on old Reddit. Click here to view the full post