codaamok/psbusinesstime

A PowerShell module with functions to help calculate working hours, and for generally working with or calculating business hours / date times.

Hi there 👋

• 🔭 I’m currently working on nothing open-source related, but a few projects at work which consume time!
• 🌱 I’m currently learning mongodb
• 🤔 I’m looking for help with learning more about mongodb
• 💬 Ask me about PowerShell, Azure, Linux, ConfigMgr (SCCM/MEMCM/MECM)
• 📫 How to reach me: Twitter
• 😄 Pronouns: he/him
• ⚡ Fun fact: I have a Beagle named Alfie - send help 🆘

psbusinesstime's Issues

Method invocation failed because [System.TimeSpan] does not contain a method named 'op_Multiply'.

Environment

Name                      Value                  
----                      -----                  
PSVersion                 5.1.19041.1682         
PSEdition                 Desktop                
PSCompatibleVersions      {1.0, 2.0, 3.0, 4.0...}
BuildVersion              10.0.19041.1682        
CLRVersion                4.0.30319.42000        
WSManStackVersion         3.0                    
PSRemotingProtocolVersion 2.3                    
SerializationVersion      1.1.0.1                

Current (as of 0.3.0)

Input

New-BusinessTimeSpan -Start (Get-Date '2022-04-01 00:00:00') -End (Get-Date '2022-04-30 23:59:59') -NonWorkingDates (Get-Date '2022-04-15'), (Get-Date '2022-04-18')

Output

Method invocation failed because [System.TimeSpan] does not contain a method named 'op_Multiply'.
At C:\Users\...\Documents\WindowsPowerShell\Modules\PSBusinessTime\0.3.0\PSBusinessTime.psm1:409 char:9
+         $InBetweenHours = $NumberOfWorkingDays * $WorkingHours
+         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (op_Multiply:String) [], RuntimeException
    + FullyQualifiedErrorId : MethodNotFound

Workaround

Patch

PSBusinessTime.psm1
Line 313

From:

$WorkingHours = New-TimeSpan -Start $StartHour -End $FinishHour

To:

$WorkingHours = (New-TimeSpan -Start $StartHour -End $FinishHour).TotalHours

PSBusinessTime.psm1
Line 409

From:

$InBetweenHours = $NumberOfWorkingDays * $WorkingHours

To:

$InBetweenHours = New-TimeSpan -Hours ($NumberOfWorkingDays * $WorkingHours)

Input

New-BusinessTimeSpan -Start (Get-Date '2022-04-01 00:00:00') -End (Get-Date '2022-04-30 23:59:59') -NonWorkingDates (Get-Date '2022-04-15'), (Get-Date '2022-04-18')

Output

Days              : 7
Hours             : 3
Minutes           : 0
Seconds           : 0
Milliseconds      : 0
Ticks             : 6156000000000
TotalDays         : 7.125
TotalHours        : 171
TotalMinutes      : 10260
TotalSeconds      : 615600
TotalMilliseconds : 615600000