根据excel中的数据，生成新的列

描述：根据源文件中的打卡时间字段，统计出早加班总时长；统计规则：早上九点之前算加班，以半小时为单位，不足半小时不累计

一.源文件

二.目标文件

三.代码实现

import openpyxl
import datetime
import math

wb = openpyxl.load_workbook('guyu.xlsx')
sheet = wb['打卡时间']

time_column = sheet.max_column + 1
# 此处可选择按行或者按列进行遍历，iter_rows iter_cols
for row in sheet.iter_rows(min_row=4, min_col=7):
    time = [cell.value[:5] for cell in row if cell.value is not None]
    time = [datetime.datetime.strptime('09:00', '%H:%M') - datetime.datetime.strptime(i, '%H:%M') for i in time]
    time = [i.seconds for i in time if i.days is 0]
    time = [math.floor(i / 1800) * 0.5 for i in time if math.floor(i / 1800) <= 3]
    sum_time = sum(time)
    if sum_time > 0:
        print(sum_time)
    sheet.cell(row=row[0].row, column=time_column).value = sum_time
sheet.cell(row=3, column=time_column).value = '早加班总时长'

wb.save('new_guyu.xlsx')
wb.close()