[日期时间] 求助批处理解析TXT文本里的时间并计算成分钟数

$txt = gc .\a.txt; ((Get-Date (($txt | select -Last 1) -split ' ')[0])-(Get-Date (($txt | select -First 1) -split ' ')[0])).TotalMinutes
复制代码

@echo off

set "file=3d.log"

for /f "tokens=1 delims= " %%a in ('findstr /b "[0-9]" "%file%"') do (
if not defined first set first=%%a
set last=%%a
)

setlocal enabledelayedexpansion
for /f "tokens=1-3 delims=:" %%a in ("!first!") do set /a m=1%%a*3600+1%%b*60+1%%c
for /f "tokens=1-3 delims=:" %%a in ("!last!") do set /a n=1%%a*3600+1%%b*60+1%%c
set /a "t1=n-m"
if !t1! lss 0 (
set /a t1=24*3600+t1
)
set /a t2=t1%%60
set /a "t1=(t1-t2)/60"
set /a t=t2*10000/60
set t=0000!t!
echo,time: !t1!.!t:~-4! mins
endlocal

pause
复制代码

gawk "$1~/([0-1]?[0-9]|2[0-3]):([0-5][0-9]):([0-5][0-9])/{split($1,a,/:/);t2=(a[1]*60+a[2])*60+a[3];if(!r){t1=t2;r=1}}END{printf(\"hh:mm:ss %02d:%02d:%02d\",(t2-t1)/3600,(t2-t1)%3600/60,(t2-t1)%60)}" 3d.log
复制代码

gawk "$1~/([0-1]?[0-9]|2[0-3]):([0-5][0-9]):([0-5][0-9])/{split($1,a,/:/);t2=(a[1]*60+a[2])*60+a[3];if(!r){t1=t2;r=1}}END{printf(\"hh:mm:ss %%02d:%%02d:%%02d\",(t2-t1)/3600,(t2-t1)%%3600/60,(t2-t1)%%60)}" 3d.log
复制代码