Posts by rapidranger61

If you're using Excel 2007, just hit up the Data tab and click remove duplicates.

wanderingraven14 said:rapidranger61... I tried formatting the whole column where my SUM shows "37:30:55" and now, say, for someone working 24 hours that week, it's showing 56:00:00... ugh...😢😢😢

Hmm, I don't know what the issue is, looks fine to me!
Maybe try it the way Nicole Collins6 would do it, should work 😉

wanderingraven14 said:God Pink Sheep 🙏🙏🙏 I'm obsessed... do you actually follow some kind of guide for this? because if you do... I'd happily be your student... love yaaa 👍

Yeah 😁

Maybe it's just the cell format for the SUM. If it's set to a standard time format, it probably resets after 24 hours. So if someone worked, I don't know, 30 hours, it won't show up right. Maybe try going into Format Cells and picking that "37:30:55" option from the list. See if that fixes it 😉

wanderingraven14 said:Oh my god guys... you are seriously the BEST!!!👍 Love you all!!! lol... here's a drink for everyone... hehe...😉 rapidranger61—you're basically a superhero... and thanks to Kyle Johnson2 too... you guys are awesome, I don't even know how to thank you...

No biggie, we'll just send you the bill later 😁

As for that other issue, that can be fixed too 😉

Say you want a date from cell A1 on the first sheet to automatically show up in A1 on sheet 2. You'd just go to that second sheet, hit cell A1, and type this formula:
=Sheet1!A1

Just gotta make sure that first sheet is actually named "Sheet1". If it's called something else, just update the formula to match.

Kyle Johnson2 said:[edit]: rapidranger61 beat me to it ;-)
idk why his post didn't show up in my browser... maybe because there was like a 30-minute gap?

Come on, man... 😁

Maybe try this formula: =IF(A1="SD";0;IF(A1>B1;B1+1-A1;B1-A1))

So, I guess your sheet should be set up so column A has the start time or "SD" if it's a day off, and column B has the end time or just stays blank if it's a day off. Then you can just drag this formula down in column C and hit SUM at the bottom. Kind of looks like this, I suppose:

22:00:00 06:00:00 =IF(A1="SD";0;IF(A1>B1;B1+1-A1;B1-A1))
SD =IF(A2="SD";0;IF(A2>B2;B2+1-A2;B2-A2))
SD =IF(A3="SD";0;IF(A3>B3;B3+1-A3;B3-A3))
8:00:00 17:00:00 =IF(A4="SD";0;IF(A4>B4;B4+1-A4;B4-A4))
7:00:00 15:00:00 =IF(A5="SD";0;IF(A5>B5;B5+1-A5;B5-A5))
=SUM(C1:C5)

EDIT: spacing on this forum is kind of weird, so sorry if it looks messy😠 All those "IF"s are actually on the same line😉

brightridge59 said:But honestly, the guy didn't give us any specifics. He didn't say exactly WHAT part of it left him feeling so blindsided. Maybe she made an insensitive comment about her ex having better equipment, or perhaps she mentioned he was more skilled in bed or even better at oral. Or maybe she brought up some wild story about a group encounter. The possibilities for awkwardness are truly endless.

And I have to respectfully disagree with the idea that a past doesn't matter. It absolutely matters. Especially if someone is still carrying all that baggage around with them. For instance, imagine you're out grabbing coffee with your girlfriend and her ex—someone she claims to be on good terms with—only to realize he's the same guy she once described as being exceptionally well-endowed or someone she used to engage in mutual masturbation with. 😁 Is that a comfortable situation to be in? I certainly don't think so.

If someone's still dragging old baggage, I guess that’s not even the past anymore—that's just their present.
But if we're talking about some guy she hooked up with years ago who means zero to her now... honestly, I don't see why that should bother her partner at all.

I mean, we don't actually know the full story here, so it's hard to give a real opinion. Could be anything. Just my vibe, though... feels like the OP is stressing over stuff that shouldn't even matter.

Alex Patel96 said:Since we're being all tolerant and liberal, let me ask something.
Would you actually accept a partner's past if it wasn't something totally trivial? (Though I guess everyone decides what's trivial for themselves)

I asked a few guys if they'd forgive or accept a partner if she had been a prostitute. Every single one said no way.
And I'm with them.
I think there are definitely some lines you just can't cross (and personally, I don't think you should). ...

Nobody's saying the past isn't important. It shapes who we are today.
But if I can't handle certain things, I'll just ask upfront. I'm not going to spend years in a relationship and then suddenly start throwing things in my partner's face that they clearly can't change. So, sure, I'll ask about the basics, but whether or not I care about their old relationships or sex life? 😁 Not really. It would bother me if it 😁

It's kinda funny how the ego struggles with romantic history... yet I've never heard anyone say, "My partner was a thief or a dealer or a scammer—I just can't deal with that." 😁

mistyraven said:I'm spiraling over my partner's past.

Look, I get it—the present is what matters, and exes are exes for a reason. But still...

Yesterday, during a conversation, I found out something I really shouldn't have. I know, I know—it’s ancient history, and we’ve been together for three years now. But somehow, this jealousy just flared up out of nowhere. Picturing the person I love doing... certain things with someone else? Yeah, not exactly a great feeling.

We were just talking about our past relationships versus how things are now. Then they dropped something on me that totally floored me. I didn't even want the details, but there it was...

I basically just stood up, grabbed my stuff, and walked out. No words. I know it wasn't the right move, but I don't know why I'm struggling so much to accept that there was a whole life before me.

Now I'm a mess. I can't even bring myself to be physical with them—it's like their past makes me feel physically repulsed.

Is this just being possessive? Or am I looking at some kind of pathological jealousy?

Man, you've got a massive issue here that's gonna make life miserable for both you and your partner. You can't change the past, and it’s definitely not something she should feel guilty about—and it sure shouldn't make you feel disgusted. Jealousy and possessiveness are tough to shake, so maybe look into therapy? You're really the only one who can fix this. Her past doesn't actually matter.

nOra said:I think digging into the past and talking about all those intimate details was pretty stupid. Your reaction feels somewhat understandable, and I bet it'll pass if she tries hard enough to prove she's all in with you now. But hey, take this as a lesson for next time: stop asking about exes.

I agree with the first part, but not the second. She shouldn't have to prove anything to him regarding things that happened before they even met. He needs to realize everyone has a history, and for any normal person, that wouldn't be an issue at all.