困惑好久的问题
有一考勤表A1.
ID checktime name
22,2009-06-14 07:38:03,张三
22,2009-06-14 12:15:33,张三
23,2009-06-14 08:01:00,李四
23,2009-06-15 07:33:28,王五
...
....
...
现要求根据日期和时间段分出谁没有打卡!(区分出漏打时段1/时段2)
如:
时段1:2009-06-14 07:30:00至2009-06-14 08:00:00
时段2:2009-06-14 12:00:00至2009-06-14 05:00:00
[解决办法]
[解决办法]
简单示例:
For i = #6/14/2009# To #7/14/2009#
ff1 = Format(i & " 01:00:00", "yyyy-mm-dd hh:mm:ss")
MsgBox ff1
Next
End Sub
自己动手做一下
[解决办法]
For i = #6/14/2009# To #7/14/2009#
hh = Format(i & " 01:00:00", "yyyy-mm-dd hh:mm:ss")
For j = 1 To 24
hh = DateAdd("h", 1, hh)
MsgBox hh
Next
Next