• 1 Post
  • 175 Comments
Joined 1 year ago
cake
Cake day: June 14th, 2023

help-circle


  • Luckily/unluckily (because effort), in Australia, consumer guarantees on length of time you can get a refund are vague.

    E.g. it doesn’t matter that a fridge’s manufacturer warranty is only 2 years, you expect that to last longer.

    With effort, you could probably get a fridge fixed like 5 years after purchase with some badgering / threatening small claims.

    Bricking your product would probably fall under that category.

    This is wild speculation, not a lawyer.


  • Naps are not recommended by sleep psychologists if you are someone who has trouble falling asleep at night anyway, unless you are extremely fatigued, and in those cases, the earlier in the day the better so you can recharge your sleep drive before night.

    But yeah, I too wish I could give myself an actual refresh during the day with a siesta, but alas no.

    I am not a sleep psychologist and this isn’t medical advice, second-hand info.




  • I don’t think any zoning laws anywhere in Australia would allow for this on public roads.

    Happy to be corrected, but this shit takes it’s toll on everyone else’s wellbeing.

    When I lived about 5 km from the city (Melbourne), I’d hear some arsehole (cars, as well as bikes) ripping it down the road at least every 20 minutes, all fucking day.

    I do not give a shit what your hobbies are, but they had better not be giving me heart disease…

    These fuckers deserve to have their bikes/cars confiscated for putting on illegal mods on the second offence. Not per vehicle, per fucking lifetime.

    You get one chance, then you had better start keeping receipts so you never have an illegal mod ever again…











  • This is because you’ve accidentally input the values as text somewhere along the line. First make sure your format is set to date in the range in question.

    Make use of the DATEVALUE formula in blank column =DATEVALUE(your_range). This will output your range as a number. Note that your_range needs to be in your computers date format (I have mine set to YYYY.MM.DD, so that what I have to use, else it won’t work. You might be American, so your dates would need to be MM/DD/YYYY) for DATEVALUE to recognise the text as a date string.

    Then copy the output, paste as values only (alt, h, v, v), then copy that and paste it back into you range.

    Make sure the format is set to date and you’re laughing.