• 2 Posts
  • 141 Comments
Joined 1 year ago
cake
Cake day: June 14th, 2023

help-circle



  • MisterFrog@lemmy.worldtoMemes@lemmy.mlI hate these icons
    link
    fedilink
    arrow-up
    26
    arrow-down
    7
    ·
    12 days ago

    I actually think these are fine. If I can quickly recognise each on my homescreen (I don’t use labels) then it’s fine, and I’ve never had a problem with any of these.

    I like it because each company each has its own set of apps, and they have somewhat unified app icons.

    Proton is the same, which similar icons as google but with their own unified branding.

    I like it, personally.



  • 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.






  • MisterFrog@lemmy.worldtoLemmy Shitpost@lemmy.worldGuess I'll km/s
    link
    fedilink
    arrow-up
    3
    arrow-down
    1
    ·
    28 days ago

    I used to do it this way in highschool, but could never remember if it was divide by or multiply by 3.6

    Instead I now do it as you have shown, except it all goes in the same expression.

    10 km/h * 1000 m/km * 1h/3600s = 2.778 m/s

    No need for the extra steps. Slap it all in the same expression and put it in the calculator (being careful to check that the units cancel as intended)


  • I dislike that my highschool never once gave me the concept that units can simply be treated like constants to be cancelled out.

    I used to do the conversions for each variable before putting them in the equation like a fool.

    Now I’m slapping all of the conversions alongside the original values/units in a single expression like god intended.