Virtualisation and more…
Posts by Rene
RES Baseline Desktop Analyzer Our Experiences
0Script Convert-ExcelSerialdate
01 year ago
When converting an Excel sheet, containing a column with dates, to a CSV file, the column in the CSV file contains nummeric values instead of date values. These numeric values are Serial dateformated values, used internal by Excel to calculate the date.
More info: Link
I wrote a Powershell function to convert the Excle serial date to a .Net date object:
Function Convert-ExcelSerialdate
{param ($nExcelSerial)
$x = (Get-Date "1899,12,31").AddDays($nExcelSerial - 1)
return [datetime]$x
}
Example code
$dates = @(32504,21252,19848,21280,21636,32364,19759,20441,20480,19038,19703)
Foreach ($date in $dates)
{
$z = convert-excelSerial($date)
Write-host $date: $z
}
Windows default user Profile
0I found a great blog post about creating a Windows default user profile.
Kef PSW2000 Subwoofer problem
0
Since a month I have a problem with my Kef PSW2000 sub-woofer. When the sub-woofer is on power is making a funny noise, a buzzing sound. The sound is originating from the back of the case.
I started searching om google for a solution to this problem. When I came across some forums, I found a site completely dedicated to problems with the Kef sub-woofers.
Update: I fixed my PSW-2000 last Saturday!!!! happy subwoofing.