Excel: Subtract Minutes from Time

So, you have a spreadsheet and you’re trying to log time entries, say for work. You work 8:00 to 4:30 and get a half hour for lunch. How do you calculate this in Excel? 1. Create a spreadsheet, and put this in column A: 8:00:00 AM 2. Put this in Column B: 4:30:00 PM 3….

0

Excel VBA: Deleting a worksheet in code

I wanted to take a moment and share a little VBA in Excel that would delete a worksheet from code. Usually, you would want to use this as a part of a larger routine. To call the Sub, use this syntax: DeleteWorksheet “xxx”, False Where xxx represents the name of the worksheet, and False (or…

0

Excel VBA: Replacing text in a specific column with code

Another really quick code snippet to replace text in a specific column through code. Usage is simple: ReplaceTextInColumn “A”, “Hello”, “Aloha” Where “A” is the column to replace text in. Hello is the text to find, and Aloha is the text to replace Hello with (thinking warm this winter). You can extend this to add…

0

SCCM 1710 and PeerCaching: Technical Notes

Executive Overview SCCM PeerCaching was first introduced in SCCM 1610 as a pre-release feature and officially added to SCCM in 1710. PeerCaching is intended to serve as an additional option for clients to download content, mostly thinking in terms of OS Deployments to accelerate the process while taking into consideration environmental factors like network bandwidth….

5

Group membership isn’t consistent in AD Users and Computers

This was the case of another interesting troubleshoot I ran across where users weren’t enumerating properly in a PowerShell script. Problem statement: An admin was working on a project known as the “Active Directory Group Cleanup”, in which they needed to find and remove members from groups. So, he created a PowerShell script using Get-ADGroupMember….

0

The future of old apps with Windows 10

The past is hard to let go of, let’s be honest. In the IT world, there is a lot of truth to some of the old tools are also some of the best. You SCCM (or dare I still say SMS) guys should know this, for those who still use things like ccmclean instead of…

1

PS without BS: Creating Random Test Users in Active Directory

This was an interesting ask, and kind of showcases a couple of different techniques. The ask was to create 20 random users in Active Directory for test purposes. So, I grabbed a list of (debateably) a list of the most common male and female first names and the most common surnames. I then randomize these…

0

Clean up Group Policy Now! – How and Why

ACT I: Introduction In my mind, one of the things that put Windows over the top in the (cough) post Windows NT4 era was the ability to manage it with this new phenomenon called “Group Policy”. If anyone remembers the days of using logon scripts (some still do), AT commands (anyone remember Kixstart?), SMS, and…

0

Troubleshooting Internet Explorer and the CRL mystery

This was an interesting case, and didn’t see much on this when I searched around the public internet, so want to leave a little something in case it helped someone else. The Problem Statement Users on Windows 7 and Internet Explorer 11 or Microsoft Edge on Windows 10 were experiencing no issues going to a…

1

Detecting port availability and blockage: Part 2, The Trace

Note: For Part 1 of this blog, “The players”, Click Here So, back to our scenatio and detecting port blocking. A little copy and paste from Part 1: Nature of blocked ports Port blocking is a somewhat secret event to tracing, but there are some very easy methods to determine if this is happening. Let’s…

0