Get-TimeSheet.ps1

function Get-TimeSheet {
    <#
    .SYNOPSIS
        Gets the contents of the timesheet file and parses it.
    .DESCRIPTION
        Gets the content of the timesheet file with the directory given by the
        -directory parameter, with the format yyyyMMdd.txt, and parses the 
        data.
    .EXAMPLE
        PS C:\> Get-TimeSheet -Directory $HOME | Format-Table

        Date                Subject               Action Duration DurationToNearest15
        ----                -------               ------ -------- -------------------
        28/07/2022 08:37:00 Daily Checks          Start  00:00:00 00:15:00
        28/07/2022 09:14:00 Daily Checks          End    00:37:00 00:45:00
        28/07/2022 09:14:00 Daily Standup         Start  00:00:00 00:15:00
        28/07/2022 10:07:00 Daily Standup         End    00:53:00 01:00:00
        28/07/2022 10:14:00 Coffee Break          Start  00:07:00 00:15:00
        28/07/2022 11:03:00 Coffee Break          End    00:49:00 00:45:00
        28/07/2022 11:03:00 Dedicated Code Review Start  00:00:00 00:15:00
        28/07/2022 11:18:00 Dedicated Code Review End    00:15:00 00:15:00
        28/07/2022 11:22:00 Daily Checks          Start  00:04:00 00:15:00
        28/07/2022 11:53:00 Daily Checks          End    00:31:00 00:30:00
        28/07/2022 11:56:00 Review Upgrade plan   Start  00:03:00 00:15:00
        28/07/2022 12:24:00 Review Upgrade plan   End    00:28:00 00:30:00
        28/07/2022 12:35:00 Prep for Upgrade      Start  00:11:00 00:15:00
        28/07/2022 12:59:00 Prep for Upgrade      End    00:24:00 00:30:00
        28/07/2022 13:00:00 Call with PM: Issue   Start  00:01:00 00:15:00
        28/07/2022 13:45:00 Call with PM: Issue   End    00:45:00 00:45:00
        28/07/2022 14:24:00 Update Meeting        Start  00:39:00 00:45:00
        28/07/2022 15:00:00 Update Meeting        End    00:36:00 00:45:00
    #>
    
    [CmdletBinding()]

    param (
        # The date of the timesheet file
        [Parameter(
            ValueFromPipeline,
            ValueFromPipelineByPropertyName
        )]
        [datetime] $FileDate = (Get-Date),

        # The directory that stores timesheet files
        [Parameter(
            ValueFromPipeline,
            ValueFromPipelineByPropertyName
        )]
        [ValidateScript({ Test-Path -Path $_ })]
        [Alias('TimeSheetDirectory')]
        [string] $Directory = (
            Split-Path -Path $PSScriptRoot -Parent |
            Split-Path -Parent |
            Join-Path -ChildPath 'TimeSheets'
        )
    )

    process {
        $dateFormatted = Get-Date -Date $FileDate -Format FileDate

        Write-PSFMessage -Level Verbose -Message 'Finding timesheets'
        try {
            $gciParams = @{
                Path        = $Directory
                Filter      = "*$($dateFormatted)*"
                ErrorAction = 'Stop'
            }
            $timeSheets = Get-ChildItem @gciParams
        }
        catch {
            Write-PSFMessage -Level Warning -Message "Cannot find timesheets matching $dateFormatted in $Directory"
            break
        }

        Write-PSFMessage -Level Verbose -Message "Parsing timesheets"
        $contents = foreach ($timeSheet in $timeSheets) {
            foreach ($content in Get-Content -Path $timeSheet) {
                if ([string]::IsNullOrEmpty($content)) { continue }

                $Date, $Action, $Subject = $content.Split(' - ', 3)

                # Deal with `-as [datetime]` not working properly...
                $Date = [datetime]::ParseExact(
                    $Date,
                    'HH:mm dd/MM/yyyy',
                    $null
                )

                [PSCustomObject]@{
                    Date    = $Date -as [datetime]
                    Action  = $Action
                    Subject = $Subject
                }
            }
        }

        Write-PSFMessage -Level Verbose -Message 'Adding Duration property'
        $prevDate = ($contents | Sort-Object -Property Date)[0].Date

        foreach ($row in $contents) {
            $duration = $row.Date - $prevDate

            if (-not (Test-Path -Path Function:\Get-ClosestToMinute)) {
                $funcImport = '{0}{1}{2}.ps1' -f @(
                    $PSScriptRoot,
                    [IO.Path]::DirectorySeparatorChar,
                    'Get-ClosestToMinute'
                    )
                Write-PSFMessage -Level Verbose -Message "Importing function from $funcImport"

                try {
                    . $funcImport
                }
                catch {
                    Write-PSFMessage -Level Warning -Message "Error importing function from $funcImport"
                }
            }

            $durationAgg = Get-ClosestToMinute -InitialTimeSpan $duration

            [PSCustomObject]@{
                PSTypeName          = 'TimeSheet'
                Date                = $row.Date
                Subject             = $row.Subject
                Action              = $row.Action
                Duration            = $duration
                DurationToNearest15 = $durationAgg.newTimeSpan
            }

            $prevDate = $row.Date
        }
    }
}