4,543 reputation
144597
bio website security.stackexchange.com
location Florida
age 32
visits member for 3 years, 11 months
seen 4 mins ago

I'm not the droid you're looking for.


Aug
3
comment Difference between Local Policy and Registry Key
Related
Aug
3
comment Difference between Local Policy and Registry Key
The Registry showing a value of "4, 30" is odd. That key is a REG_DWORD, which means you should only be seeing a hex value and its decimal equivalent. The Windows default is 0x0000001e (30). (Though, interestingly enough that does not match the default Local Policy value of 42.)
Aug
1
revised Turning students’ marks into grades with excel
added 179 characters in body
Aug
1
answered Turning students’ marks into grades with excel
Aug
1
comment Finding IPs covered by Subnets in an Excel document
Without zero-padding, writing formulas to handle IPs properly in Excel can be tricky. I was starting to come up with some fairly simple ideas, but they won't work right unless each octet is exactly three digits long.
Aug
1
comment Using Excel to calculate time differences with blank cells and calculate monthly totals
SUM usually handles blanks and non-numeric values quite gracefully. What have you tried?
Aug
1
comment Use Windows 8 Pro 64-bit OEM licence in VirtualBox
Not sure if this is true for Windows 8, but I know earlier versions had different images for OEM & Retail packages and you couldn't use the key for one with a disc made for the other.
Aug
1
revised how to create a YES NO notification for time?
added 801 characters in body
Aug
1
revised how to create a YES NO notification for time?
added 801 characters in body
Aug
1
comment how to create a YES NO notification for time?
But... now I still can't figure out why. I mean, if the formula in P2 only returns hours and minutes, that shouldn't even be necessary.
Aug
1
comment how to create a YES NO notification for time?
Oh, wait... I think I figured out the MOD. It's a hacky way of extracting the time portion from an Excel date/time serial number. Since the hours/minutes/seconds are encoded as a fraction of one day, MOD 1 would strip the date off and only leave the time.
Aug
1
revised how to create a YES NO notification for time?
added 11 characters in body
Aug
1
answered how to create a YES NO notification for time?
Aug
1
comment Change color of a cell based on the difference between 2 cells
Basic on/off Conditional Formatting is fairly simple - just give it a formula that evaluates to TRUE when you want the formatting applied, and FALSE when you don't.
Aug
1
comment Excel date & time formula-round up cell value
Can't tell for sure from the details here, so anything's possible. There's about thirty different ways to skin this cat regardless.
Aug
1
revised Change color of a cell based on the difference between 2 cells
added 535 characters in body
Aug
1
comment Change color of a cell based on the difference between 2 cells
@Bryon So you want a simple formatting toggle, not a progressive scale?
Aug
1
revised Excel to calculate summation with exclusion list
added 299 characters in body
Aug
1
answered Excel to calculate summation with exclusion list
Aug
1
answered Excel date & time formula-round up cell value