If you ever need to display hidden devices in your devide manager, run the following from a Command Line window, or create a short script (show_hidden_devices.cmd) with the following content:
set devmgr_show_nonpresent_devices=1
start devmgmt.msc
I was trying to set up a simple time sheet in Excel. I know that ready-made ones exist, but it’s more fun and educating to make your own, right? And I came across a nasty problem: Excel doesn’t like to display negative time:
Turns out there’s a simple solution for this: Enable the 1904 dating system. There is also a workaround formatting the result as text, but Microsoft states that this then can not be used for further calculations – not a viable solution for a time sheet!
To enable the 1904 dating system, go to your Excel options. It can be found under “Advanced” – you need to scroll quite a bit down:
Enable the option, and lo and behold – it works:
I have been having a problem with one of my WordPress blogs that had me stumped: Whenever I would comment on it, being logged in as my WordPress user, I would get the error message:
“please fill the required fields (name, email).”
This started happening out of nowhere, without any connection to an update as far as I could tell. I even went so far as to check the code of my child theme – nothing. And I could not find any matching posts on the WordPress forums either…
It turned out to have a very simple solution. I disabled Jetpack, re-enabled it, and authorized Jetpack with WordPress.com again and lo and behold, the problem is gone.
No idea what the actual cause was, but this was one solution I did not try for some time – so I hope this helps anybody who is similarly stuck. 😉
It’s the small things, sometimes – something I never needed to do in my old jobs is calculating with time. One very simple task is to just add up a set of times – Excel will “wrap around” at 24h:
There’s a simple solutions for this problem. Just surround your hours with square brackets when formatting the cell, like so:
Works like a charm:
25h not 1h
🙂