python编程工时计算_python 两个时间段过滤求交集（工时计算）-CSDN博客

本文链接：https://blog.csdn.net/weixin_35712811/article/details/113675020

该博客介绍了如何使用Python计算两个时间段的交集，并在多个时间段中进行过滤，以确定实际工时。通过将时间转换为时间戳并进行比较，可以找出工时计算中排除非工作时间的部分。示例代码展示了如何处理开始和结束时间在规定工作时间之外的情况，并计算实际有效工时。

摘要由CSDN通过智能技术生成

import time

# 输入的开始时间和结束时间

# start = "2020-01-03 10:00:00"

# end = "2020-01-03 13:30:00"

# start = "2020-01-03 12:00:00"

# end = "2020-01-03 13:30:00"

# start = "2020-01-03 12:10:00"

# end = "2020-01-03 13:00:00"

start = "2020-01-03 13:00:00"

end = "2020-01-03 18:00:00"

# 单个时间段过滤

# 要过滤出的时间段

standard_start = "2020-01-03 12:00:00"

standard_end = "2020-01-03 13:30:00"

# 将时间转换为时间戳方便下面 if 语句使用比较

startTimeStamp = int(time.mktime(time.strptime(start, "%Y-%m-%d %H:%M:%S")))

endTimeStamp = int(time.mktime(time.strptime(end, "%Y-%m-%d %H:%M:%S")))

standardStartTimeStamp = int(time.mktime(time.strptime(standard_start, "%Y-%m-%d %H:%M:%S")))

standardEndTimeStamp = int(time.mktime(time.strptime(standard_end, "%Y-%m-%d %H:%M:%S")))

# 定义一下开始时间的差值和结束时间的差值，为了避免后面两个 if 语句匹配不上时，不能使用这两个变量

startDifferentTime = 0

endDifferentTime = 0

# 规定时间范围也就是指正常规定的工作时间

if(standardStartTimeStamp < startTimeStamp < standardEndTimeStamp):

# 说明开始时间在规定时间范围之外

startDifferentTime = standardEndTimeStamp - startTimeStamp

if(standardStartTimeStamp < endTimeStamp < standardEndTimeStamp):

# 说明结束时间在规定时间范围之外

endDifferentTime = endTimeStamp - standardStartTimeStamp

# 算出真正的工作时间单位为 s

timeDifferent =(endTimeStamp - startTimeStamp) - (startDifferentTime + endDifferentTime) if (startDifferentTime + endDifferentTime) > 0 else (endTimeStamp - startTimeStamp) - 1.5 * 3600

# 判断一下若真正工作时间小于 0，则为 0，不小于 0，则为本身

timeDifferent = timeDifferent if timeDifferent>0 else 0

print(timeDifferent)

# 转换工作时间的单位

timeDifferentHour = (timeDifferent / (60*60))

print(timeDifferentHour)

# 多个时间段过滤

timeFilterList = [["2020-01-03 12:00:00","2020-01-03 13:30:00"],["2020-01-03 14:00:00","2020-01-03 16:30:00"]]

standardTimeStamp = 0

startTimeStamp = int(time.mktime(time.strptime(start, "%Y-%m-%d %H:%M:%S")))

endTimeStamp = int(time.mktime(time.strptime(end, "%Y-%m-%d %H:%M:%S")))

for i in timeFilterList:

startDifferentTime = 0

endDifferentTime = 0

standardStartTimeStamp = int(time.mktime(time.strptime(i[0], "%Y-%m-%d %H:%M:%S")))

standardEndTimeStamp = int(time.mktime(time.strptime(i[1], "%Y-%m-%d %H:%M:%S")))

if (standardStartTimeStamp < startTimeStamp < standardEndTimeStamp):

# 说明开始时间在规定时间范围之外

startDifferentTime = standardEndTimeStamp - startTimeStamp

if (standardStartTimeStamp < endTimeStamp < standardEndTimeStamp):

# 说明结束时间在规定时间范围之外

endDifferentTime = endTimeStamp - standardStartTimeStamp

standardTimeStamp = standardTimeStamp + (endDifferentTime + startDifferentTime) if (endDifferentTime + startDifferentTime) > 0 else standardTimeStamp + (standardEndTimeStamp - standardStartTimeStamp)

timeDifferent = endTimeStamp - startTimeStamp - standardTimeStamp

timeDifferent = timeDifferent if timeDifferent > 0 else 0

timeDifferentHour = (timeDifferent / (60*60))

print(timeDifferentHour)

原文链接:https://blog.csdn.net/jueji1998/article/details/112361249