Skip to main content
 首页 » 编程设计

python之如何在 Python 中将时间差累积到一个变量中

2024年10月25日9bhlsheji

我是一个 Python 新手,我真的很难将耗时累积到一个变量中。数据来自时间和考勤程序。我要寻找的是在每条记录中给定开始日期/时间和结束日期/时间的给定时间段内的总工作时间。我的代码如下:

import pyodbc 
import datetime  
import time 
 
fname = "\\\\frontoffice\z\data.mdb" 
sname = "\\\\frontoffice\z\secured.mdw"     
connect_string = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + fname +";UID=me;PWD=password;systemDB=" + sname + ";" 
 
cnxn = pyodbc.connect(connect_string) 
cursor = cnxn.cursor() 
SQL = "SELECT EmpID, Weekending, Department, PayType, StartTime, EndTime FROM EmpHours WHERE EmpID=" + str(1) + " AND Weekending = #28/03/2015#;" 
ttime = 0.0 
 
for timerec in cursor.execute(SQL): 
    print timerec.Department, timerec.PayType, 
    if timerec.StartTime is not None: 
        print timerec.StartTime, 
    else: 
        print "", 
 
    if timerec.EndTime is not None: 
        print timerec.EndTime, 
    else: 
        print "", 
 
    if timerec.StartTime is not None and timerec.EndTime is not None: 
        print timerec.EndTime - timerec.StartTime 
 
        #ttime = ttime + timerec.EndTime - timerec.StartTime 
 
        print ttime 
 
    else: 
        print "n/a" 

我的输出是:

Admin Regular 2015-03-23 17:04:33 2015-03-23 17:04:41 0:00:08 
0.0 
Admin Regular 2015-03-23 17:04:51 2015-03-23 17:04:57 0:00:06 
0.0 
Admin Regular 2015-03-23 17:05:04  n/a 
Admin Regular 2015-03-23 17:05:13 2015-03-23 17:05:20 0:00:07 
0.0 
Admin Regular 2015-03-23 17:05:26 2015-03-23 17:05:33 0:00:07 
0.0 
Admin Regular 2015-03-23 17:06:09 2015-03-23 17:06:15 0:00:06 
0.0 
Admin Regular 2015-03-23 17:06:22 2015-03-23 17:06:28 0:00:06 
0.0 
Admin Regular 2015-03-23 17:06:35 2015-03-23 17:06:42 0:00:07 
0.0 
Admin Regular 2015-03-23 17:07:17 2015-03-23 17:07:23 0:00:06 
0.0 
Admin Regular 2015-03-23 17:07:29 2015-03-23 17:07:35 0:00:06 
0.0 
Admin Regular 2015-03-23 17:07:42 2015-03-23 17:07:48 0:00:06 
0.0 
Admin Regular 2015-03-23 17:08:45 2015-03-23 17:08:52 0:00:07 
0.0 
Admin Regular 2015-03-23 17:08:59 2015-03-23 17:09:05 0:00:06 
0.0 

我似乎无法将 timerec.StartTime/EndTime 更改为纪元以来的秒数,也无法将 ttime 初始化为空的 datetime.datetime 变量。有什么想法吗?

请您参考如下方法:

您已经有了 datetime.datetime() 对象,减去它们会得到一个 datetime.timedelta()。只需对这些对象求和即可:

ttime = datetime.timedelta() 
 
for timerec in cursor.execute(SQL): 
    if timerec.StartTime and timerec.EndTime: 
        ttime += timerec.EndTime - timerec.StartTime 

在for 循环结束时,ttime 是一个timedelta() 对象,代表工作的总时间。您可以将其表示为秒数:

ttime_seconds = ttime.total_seconds()