Technology

Excel time calculation and formatting

Leave a comment

It’s actually really simple, but for some reason I just keep having to look up some of these… so… finally… note to self…

Calculations =X+Y
=X+N
=Y-X
Etc.		 12:45 - 9:55 = 2:50
Time to decimal =X*24 2:50 * 24 = 2.83
Decimal to time =X/24 2,83 / 24 = 2:50
Days, hours, minutes d h:mm 11 19:20
Total hours and minutes [h]:mm 283:20
Total minutes [m] 17000

Regarding the formatting, without the brackets, it formats as regular time (total hours % 24). So, for example, 2 hours and 50 minutes multiplied by 100; with a regular time format (h:mm) it displays as 19:20; using brackets ([h]:mm) you get the correct 283:20, which is 11 days 19 hours and 20 minutes (hence the 19:20 from h:mm).

Excel screenshot

Technology

How to add certificates to the Windows certificate store

Leave a comment

There’s a command-line tool called certutil one can use to add (among other things) certificates to the certificate store in windows.

Some examples:

REM Add pfx-file to Personal
certutil -ent -p pfxpassword -importpfx my some.pfx

REM Add pfx-file to Trusted Root Certification Authorities
certutil -ent -p pfxpassword -importpfx root some.pfx

REM Add cer-file to Trusted Root Certification Authorities
certutil -ent -addstore root some.cer
Technology

Manage saved windows passwords

Leave a comment

Logged into a windows share via explorer and hit the Remember Password option. Even though the login was accepted (and saved) it turned out I had used the wrong ad domain name…

Couldn’t find where to reset/change/”logout” again, but eventually found there’s a built-in command-line tool one can use for managing these saved passwords. Think I’ve seen a control panel type thing to do this too in the past, but just couldn’t find it today… Anyways, command-line is nice, so, using imaginary share \\foobar.int, here’s some stuff one can do:

> cmdkey /list
> cmdkey /list:foobar.int

> cmdkey /delete:foobar.int

> cmdkey /add:foobar.int /user:domain\username /pass
Software Development

Heroku deploy sub-directory

2 Comments

Going through a couple of Udemy courses, and figured it was nice to keep all the code I wrote while doing them in a single github repository.

Was working nicely until I started the Node with React where part of the course is to deploy the app to Heroku which wants a full repository pushed to a certain git repo it creates for deployment. But in my case the app I want to deploy is of course a sub-directory…

Turns out there’s a git command called subtree one can use here:

# Setup
heroku login
heroku create

git remote add heroku/some-name https://git.heroku.com/{created-heroku-app-id}.git

# Deploy
git subtree push --force --prefix path/to/app heroku/some-name master

The subtree command needs to be run from the top-level directory of the git repository, but one can add a script command to the apps package.json, for example like this:

{
  "scripts": {
    "deploy": "cd ../../.. && git subtree push --prefix path/to/app heroku/some-name master"
  }
}

Unfortunately, subtree push doesn’t support --force, but a workaround for that is running it nested like this:

git push heroku/some-name `git subtree split --prefix path/to/app master`:master --force

Which unfortunately doesn’t work on Windows… but you can do it in two steps instead:

git subtree split --prefix path/to/app master
git push heroku/some-name {id-from-previous-command}:master --force
Software Development

Stop Git from messing with my newlines

Leave a comment

I’m sorry, but I just hate when Git is messing with my files… That’s just not its job!

warning: CRLF will be replaced by LF in …
The file will have its original line endings in your working directory.

Local fix

To fix it on your computer, set core.autocrlf to `false.

# This shows what it's set to now, and where
> git config --show-origin core.autocrlf

Then either edit the file manually, or do one of the following:

# System level (might disappear with git upgrades?)
> git config --system core.autocrlf false

# User level (probably preferred)
> git config --global core.autocrlf false

# Repo level (no point, use .gitattributes instead)
> git config --local core.autocrlf false

Shared repository fix

For shared projects, others might not have set this or even want to set this, so to prevent issues there, creating a .gitattributes file at the root of the repo with the following contents should fix things:

* -text

Source: How to express core.autocrlf = false with .gitattributes

Renormalization

For already messed up repos or working-copies, after changing core.autocrlf, you might be able to renormalize the files one of the methods described in this answer on StackOverflow.

With a hint of Social Ineptitude