Delete rows based on multiple conditions in PowerShell

Here is a working solution.

$file  = 'salehouses.xlsx'
$sourcePath = 'C:\some\path\'
$sourceFile = $sourcePath + $file

$excel = New-Object -ComObject Excel.Application
$excel.Visible = $false
# open file
$workbook = $excel.Workbooks.Open($sourceFile)
$sheet    = $workbook.Worksheets.Item(1)
# get max rows
$rowMax   = $sheet.UsedRange.Rows.Count

# start at last row
for ($rowNumber=$rowMax; $rowNumber -ge '2'; $rowNumber--){
    $city = $sheet.Cells($rowNumber,2).value2
   
    if ($sheet.Cells($rowNumber,3).text -ne $null -and $sheet.Cells($rowNumber,3).text -ne ""){
         # 24 hour format
        $regTime = get-date -Format "MM/dd/yyyy HH:mm" $sheet.Cells($rowNumber,3).text
        # 24 hour format
        $currentTime = Get-Date -Format "MM/dd/yyyy HH:mm"        
       
        $timeDifference = (NEW-TIMESPAN -Start $regTime -End $currentTime)
        Write-Host "time difference (hours): " $timeDifference.TotalHours

        if ($city -eq "bolton" -and $timeDifference.TotalHours -le '24') {
            Write-Host "Delete"
            $null = $sheet.Rows($rowNumber).EntireRow.Delete() 

        }
    }
}







$Filename = 'salehouses_modified.xlsx'
$path = 'c:\some\path\'
$fullPathModified =$path + $Filename
$workbook.SaveAs($fullPathModified)
$excel.Quit()

Source for getting time difference

Notes

In your original code you have the right idea of getting the used range count and looping through that and also not reading the header. You also were able to compare one cell you just needed to grab the cell in the hours column as well.

If you want to do something based on multiple conditions being met use -and in the if statement.

One quirk you may notice is when getting the date cell I had to use .text instead of .value2 like the other cell. I'm not exactly sure why but I think it's because excel formatted the cell as a date and it had a different format stored in .value2 while .text held the value we wanted.

I would recommend practicing using different conditional statements and the Get-Date command like the other commenter suggested, to get more comfortable with what's happening in the above code.

Some Edits

There were some issues with my code. Starting at 0 and counting up in the for loop is incorrect as rows are being deleted and the numbering gets thrown off. Starting at last row and counting down fixes issue.

The second issue was the times were in 24-hour format which I didn't catch originally. Fixed the code Get-Date -Format "MM/dd/yyyy HH:mm" so it read both the registration time and current time as 24-hour format. The time comparison for totaling hours was also off. Using .TotalHours instead of .hours like I had it gives the correct difference.