- ©«¤l
- 559
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 626
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-6-14
|
¦^´_ 5# imzues
³o¬O¤p§Ì~ ¦Û¤v¼gªºÂ²³æ³B²z¤è¦¡
¦]¬°¤£¤Ó¼ô½m«ç»ò§â¤é´Áȧì¥X¨Ó«áÁÙ«O¯d¬O¤é´Áªº®æ¦¡~ ©Ò¥H¦h§Q¥Î¤@¨Ç¨BÆJ¨Ó³B²z~
¤p§Ì¤]¤£¤Ó·|¥Îarray(°}¦C)ªº¤è¦¡¨Ó¼g~ ´N¥Î©Ò¼gªº¤è¦¡¨Ó³B²z~
¶Â¿ß~ ¶À¿ß~ §ì±o¨ì¦Ñ¹«ªº´N¬O¦n¿ß~ ¶È¨Ñ±z°Ñ¦Ò~ À³¸Ó«Ü®e©ö¤F¸Ñ§Ú¦b¼g¨Ç¤°»ò~
1.³B²z"¤é´Á®æ¦¡" (¤è«Kfind¦b§ä¬Û¹ïÀ³ªº¤é´Á¦ì¸m)
2.³B²z®É¶¡ªº¦ì¸m (¦]¬°¬O©T©wªº¦ì¸m,©Ò¥H¥Îif§PÂ_¸Óµ§¸ê®Æ¬O¸¨¦bþ¤@¦Cªº¦ì¸m)
3.´M§ä¥¿½Tªº¦ì¸m,±a¤JÈ (¨Ìk¹ïÀ³¨ìªº¦ì¸m«á,¦V¤U(¦C)²¾°Êd-3,±a¤JÈ,¥~¥[¤@Óif¥ý¦æ§P¬q¬O¤£¬O¦³È,Y¦³È´N²Ö¥[)
Sub xx()
Do Until Sheet1.Cells(4 + N, 5) = ""
'======³B²z¤é´Á======
Sheet1.Range("A1") = Year(Sheet1.Cells(4 + N, 5)) & "/" & Month(Sheet1.Cells(4 + N, 5)) & "/" & Day(Sheet1.Cells(4 + N, 5))
A = Sheet1.Range("A1") 'A: ³B²z¸ê®Æªº¤é´Á
Sheet1.Range("A1").ClearContents
'======³B²z¤é´Á======
'======³B²z®É¶¡ªº¦ì¸m======
b = Hour(Sheet1.Cells(4 + N, 5))
c = Minute(Sheet1.Cells(4 + N, 5))
If b < 3 And c <= 59 Or (b = 4 And c = 0) Then
d = 4
ElseIf b < 7 And c <= 59 Or (b = 8 And c = 0) Then
d = 5
ElseIf b < 11 And c <= 59 Or (b = 12 And c = 0) Then
d = 6
ElseIf b < 15 And c <= 59 Or (b = 16 And c = 0) Then
d = 7
ElseIf b < 19 And c <= 59 Or (b = 20 And c = 0) Then
d = 8
ElseIf b < 23 And c <= 59 Or (b = 24 And c = 0) Then
d = 9
End If
'======³B²z®É¶¡ªº¦ì¸m======
Set k = Sheet1.Range("I3:K3").Find(A, LookIn:=xlFormulas)
If k.Offset(d - 3, 0) = "" Then
k.Offset(d - 3, 0) = Sheet1.Cells(4 + N, 5).Offset(0, 1)
Else
k.Offset(d - 3, 0) = k.Offset(d - 3, 0) + Sheet1.Cells(4 + N, 5).Offset(0, 1)
End If
N = N + 1 'N¬°³B²z¤U¤@µ§¸ê®Æ¤§°Ñ¼Æ
Loop
End Sub |
|