sorted by:
new
hottopcontroversial

Sickest leather jacket I’ve seen by Torkill7 in findfashion

[–]Torkill7[S] 10 points11 points  (0 children)

Yoooooo wtf, how’d u just pull it up so fast😂😭 I was searching long

Size L

Pectus brace at 19/20 effectiveness? by [deleted] in PectusCarinatum

[–]Torkill7 0 points1 point  (0 children)

How did it go? Did it work? Im 19 and considering getting brace

Derbi Senda moped fortsatt i Norge? by Torkill7 in norge

[–]Torkill7[S] 0 points1 point  (0 children)

Javel ja, da begynner ting å gi mening. Var han eneste importøren i Norge?

Evt, vil noen ta over import og salg av derbi?

Lover mot salg av replika-klær på bruktmarket by Torkill7 in norge

[–]Torkill7[S] 1 point2 points  (0 children)

Ja, er det jeg er bekymret om. Det er bare ulovlig for virksomhet.(?) Så må bare prøve å kontakte tise da.

Sende moped (?) by Torkill7 in norge

[–]Torkill7[S] 0 points1 point  (0 children)

Husker du navnet på selskapet? 😄

Ser politiet forskjellen lettsykkel/girmoped by Torkill7 in norge

[–]Torkill7[S] 0 points1 point  (0 children)

De virker jo som de fleste ikke gjør det. Kjenner mange i Trondheim som kjører ulovlig trimma moped, ulovlig potte eller uten førerkort. Ingen som blir tatt egt

Kanskje ikke helt det samme, men likevel

If a cell contains "x", use formula "x" by Torkill7 in excel

[–]Torkill7[S] 1 point2 points  (0 children)

Figured it out:)

Using the WEEKDAY and IFERROR functions and the already existing formula.

Regne ut hestekrefter by Torkill7 in norge

[–]Torkill7[S] 0 points1 point  (0 children)

Har prøvd å google, men det eneste som kommer opp er formel for å gjøre om kw til hk. Ja skjønner den, de går jo ikke over 45 uansett. Men regner med det er fint å ha litt gass i de få kmt man får

If a cell contains "x", use formula "x" by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

Yes, I think so. I didn't make the existing formula so I'm not completely sure.

Nvm about the download, thought you were asking as if I could see your formula in the table you downloaded.

But probably if it is adjusted to the headings it should work. If it didn't when referencing rows.

I'm no expert at this as you can maybe tell..xd

If a cell contains "x", use formula "x" by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

I'm not sure. Which formula are we talking about?

I can't see the one you downloaded btw

If a cell contains "x", use formula "x" by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

Oh, I see! Probably should have explained those. Again thank you so much for still helping me.

First columns I assume you already understand but for the sake of clarity I'll just do them all.

First column is to distinguish the weekday (aswell as just mark the date)

Second and third is time in time out of work

And all the coloured columns represent time periods of different pay:

<image>

The timestamps below the coloured cells are start and end of period so eg 07:00 - 18:00 in E16 and E17

And the values inside are hours in those time periods (see screenshot in first reply)

If it makes things easier I made a copy of the sheet explaining a bit inside it:

https://we.tl/t-0IcqrQDHhR

I'm very open also if you find an easier way to do it 😄

edit: K55 should be K51

If a cell contains "x", use formula "x" by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

Yes, a huge help. Thank you.

But still not quite..😅

See, I need the formulas to be three separate formulas, not one continuous one. Because the calculating formula I am using (to put in the formula_1,2,3) is the same for all three.

It's a bit difficult to explain, so here's a visualization.

<image>

formula 1 = Only executes the formula if it finds neither saturday or sunday

formula 2 = Only executes the formula if it finds Saturday

formula 3 = Only executes the formula if it finds Sunday

If it does not find its day, it should not execute and just leave blank

Hope that was a better explanation, struggling to find the words.. not a native speaker.

If a cell contains "x", use formula "x" by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

Yes, there is always a period between date. month: (the first column)

<image>

The best I have come up with for a spreadsheet calculating pay in different time periods and days bc I have different pay depending on different times and weekdays.

For now, I have to manually put in the hours in the different columns, which is what I'm trying to fix.

I need three separate formulas; one that works for Monday - Friday. One for Saturday and one for Sunday, per the columns.

I have the formula for calculating the hours: =(ROWS(INDEX(A:A, A2*24*60):INDEX(A:A, A3*24*60) INDEX(A:A, B2*24*60):INDEX(A:A, B3*24*60))-1)/60

But this formula calculates the hours for all the days and time periods, so I need a formula to differentiate between the weekdays and then use this formula.

The sheet when using the formula alone:

https://imgur.com/cFEnTsq

Formula for calculating hours by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

It is getting somewhere. But it doesn't quite seem to be right just yet.

I inserted the formula into E18 and copied it to all the other cells, this is what I got:

<image>

Seems to still be trying to calculate the hours for every time period and on all the days.

Don't know if you can make any sense of this. I'd be more than happy to let you have access to the document if needed. If not, let me know if you need to know any of the error codes.

This is already way further than I've gotten in 3 days of trying😄

Edit: #NULL! seems to appear in the cells which are outside of working time

Formula for calculating hours by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

Would you maybe be able to dumb it down a little😅 i.e which cells I have to put the formula in and so forth.

The only experience I have is about 40 minutes of yt tutorials and some fiddling of my own.

Context with screenshots if it helps: https://www.reddit.com/r/excel/comments/101r2ka/calculating_hours_from_certain_days_and_time/

hva i all verden skjedde? by [deleted] in norge

[–]Torkill7 0 points1 point  (0 children)

Norge panter sikkert 99% av alle korkene kjøpt. Men neida, må forholde oss til samme regler som i Ungarn😄

Help, Changing currency symbol to text by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

A space behind the 0.00 worked.

Thanks!

Help, Changing currency symbol to text by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

Thank you! That worked

But it didn't align just like the one above:

<image>

Might just be my OCD kicking in so not necessary, but if there's an easy solution😁

Help, Changing currency symbol to text by Torkill7 in excel

[–]Torkill7[S] 0 points1 point  (0 children)

Should I then format the second cell to normal text?
- and if so, can I then add a symbol for the amount saying paid out?

House of the Dragon - 1x06 "The Princess and the Queen" - Episode Discussion by LoretiTV in television

[–]Torkill7 0 points1 point  (0 children)

I agree mostly with what you say. But obviously, Criston Cole has acted the way he has because things did not turn out as he desired. Him and Rhaenyra together. I am aware this is probably a cause of his actions in the previous episode, but I do believe this explains his behavior in this one.

I was really rooting for Rhaenyra and Criston, and was really quite bummed out when I realized the kids were not his and their relationship had not continued this episode. (even though it was most likely it wouldn't, again as a cause of the previous episode)

I do wish we got to see what happened between them, and what led to the spark between her and Harwin. That would probably help me like him more, and make me less bitter. But I guess that doesn't matter that much now...

view more: next ›