Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to add HH:MM:SS:MS 1

Status
Not open for further replies.
Tester_V

Tester_V

Technical User
Joined
Nov 22, 2019
Messages
54
Location
US
Hi,
Does anybody knows how to add times in Python?
Need to add HH:MM:SS:MS
The file goes like this:
5/1/2020 2:40:31 PM, 5/1/2020 2:43:11 PM, 00:02:40.5449136,
5/1/2020 2:45:26 PM, 5/1/2020 2:48:17 PM, 00:02:50.8250927,
the third column is a timduration, need to sum it up.

Thank you.
 
Sort by date Sort by votes
Hi

Tester_V said:
Does anybody knows how to add times in Python?
Click to expand...
Fortunately Python has a dedicated [tt]timedelta[/tt] class for that purpose ( just like Java has [tt]Period[/tt] and PHP has [tt]DateInterval[/tt] ). That makes calculations simple ( and with Python's overloaded operators also intuitive ).
Unfortunately [tt]timedelta[/tt] has no dedicated method to initialize it from a string, like [tt]datetime[/tt]'s [tt].strptime()[/tt], so you have to spoonfeed it with integers :
Python: 
[red]from[/red] datetime [red]import[/red] datetime[teal],[/teal] timedelta
[red]import[/red] re

with [COLOR=orange]open[/color][teal]([/teal][i][green]'Tester_V.txt'[/green][/i][teal])[/teal] as file[teal]:[/teal]
    [b]for[/b] line [b]in[/b] file[teal]:[/teal]
        part [teal]=[/teal] line[teal].[/teal][COLOR=orange]split[/color][teal]([/teal][i][green]', '[/green][/i][teal])[/teal]

        first [teal]=[/teal] datetime[teal].[/teal][COLOR=orange]strptime[/color][teal]([/teal]part[teal][[/teal][purple]0[/purple][teal]],[/teal] [i][green]'%m/%d/%Y %I:%M:%S %p'[/green][/i][teal])[/teal]
        second [teal]=[/teal] datetime[teal].[/teal][COLOR=orange]strptime[/color][teal]([/teal]part[teal][[/teal][purple]1[/purple][teal]],[/teal] [i][green]'%m/%d/%Y %I:%M:%S %p'[/green][/i][teal])[/teal]

        deltapart [teal]= [[/teal][COLOR=orange]int[/color][teal]([/teal]one[teal])[/teal] [b]for[/b] one [b]in[/b] re[teal].[/teal][COLOR=orange]findall[/color][teal]([/teal]r[i][green]'\d+'[/green][/i][teal],[/teal] part[teal][[/teal][purple]2[/purple][teal]])][/teal]

        delta [teal]=[/teal] [COLOR=orange]timedelta[/color][teal]([/teal]hours [teal]=[/teal] deltapart[teal][[/teal][purple]0[/purple][teal]],[/teal] minutes [teal]=[/teal] deltapart[teal][[/teal][purple]1[/purple][teal]],[/teal] seconds [teal]=[/teal] deltapart[teal][[/teal][purple]2[/purple][teal]],[/teal] microseconds [teal]=[/teal] deltapart[teal][[/teal][purple]3[/purple][teal]])[/teal]

        [b]print[/b][teal]([/teal][i][green]'%s + %s = %s'[/green][/i] [teal]% ([/teal]first[teal],[/teal] delta[teal],[/teal] first [teal]+[/teal] delta[teal]))[/teal]
        [b]print[/b][teal]([/teal][i][green]'%s + %s = %s'[/green][/i] [teal]% ([/teal]second[teal],[/teal] delta[teal],[/teal] second [teal]+[/teal] delta[teal]))[/teal]


Feherke.
feherke.github.io
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

phadobas
  • Question Question
Need some help with "nicegui"
Replies
5
Views
262
SoftwareRT
SoftwareRT
Jongskie M.
  • Locked
  • Question Question
Copying current file to destination
Replies
5
Views
2K
mikrom
mikrom
Aaron5
  • Locked
  • Question Question
Add column headings with TKinter grid and centering
Replies
0
Views
1K
Aaron5
Aaron5
Ravi Kashyap
  • Locked
  • Question Question
How to create Python reports just like foxpro?
Replies
3
Views
1K
Ravi Kashyap
Ravi Kashyap
Jongskie M.
  • Locked
  • Question Question
How to open a folder in Python command after it was been created automatically?
Replies
2
Views
1K
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top