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

help-circle





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




  • It would make sooo much more sense for the ISO to set something up, and make governments each responsible for keeping it updated, since they’re the ones doing the changing.

    Require all participants to amend their law/regulations, so there’s a note to prompt whoever is in power and changes it next.

    I’m sure some places would still neglect to do it… Haha