我需要相应地查看现在的几点:
I needed to see accordingly to what time is now the following:
-
如果时间在8:00:00之间和22:00:00请参阅:
if time is between 8:00:00 and 22:00:00 see:
现在是棘手的部分
-
如果时间在22:00:00和23:59:59之间,请查看:
if the time is between 22:00:00 and 23:59:59 to see:
,如果时间在00:00:00到8:00:00之间,则可以看到:
and if the time is between 00:00:00 and 8:00:00 to see:
"[[Night shift (previous day number) - (current day number) (month name)]]"
使其在Excel中工作我对Python没有经验。
Made it to work in Excel I'm not experienced with Python.
= IF(AND(MOD(Sheet4!A1,1)> TIME(8,0,0),MOD(Sheet4!A1,1)TIME(8,0,0),MOD(Sheet4! A1,1)TIME(20,0,0),MOD(Sheet4!A1,1)TIME(20,0,0),MOD(Sheet4!A1,1)TIME(0,0,59),MOD(Sheet4 !A1,1)TIME(0,0,59),MOD(Sheet4) !A1,1)
我无法向您展示所有excel公式:/不知道为什么
=IF(AND(MOD(Sheet4!A1,1)>TIME(8,0,0),MOD(Sheet4!A1,1)TIME(8,0,0),MOD(Sheet4!A1,1)TIME(20,0,0),MOD(Sheet4!A1,1)TIME(20,0,0),MOD(Sheet4!A1,1)TIME(0,0,59),MOD(Sheet4!A1,1)TIME(0,0,59),MOD(Sheet4!A1,1)
I am unable to show you all the excel formula :/ no idea why
= NOW()
非常感谢!
推荐答案使用 datetime 模块:
from datetime import datetime, timedelta now = datetime.now() if now.hour < 8: print("[[Night shift {yesterday.day} - {today.day} {today.month}]]" .format(today=now, yesterday=now-timedelta(1))) elif now.hour >= 22: print("[[Night shift {today.day} - {tomorrow.day} {today.month}]]" .format(today=now, tomorrow=now+timedelta(1))) else: print("[[Day shift {today.day} {today.month}]]".format(today=now))更多推荐
根据当前时钟时间输出日夜转换时间
发布评论