ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ·í²Å¦X±ø¥ó®É¦^¶ÇSample time & ¨äÀx¦s®æ¦C¸¹

¦^´_ 10# marklos

½Æ»s¤U¦C¥N½X¶K¤W¥h¨ú¥Nªº´N¦æ¤F
  1. Private Sub CommandButton1_Click()
  2. [g5,h5] = ""
  3. For Each cu In Range("d2:d" & [a65536].End(3).Row)
  4. If cu.Value < [g2] Then
  5.   [g5] = cu.Offset(0, -2).Value
  6.   [h5] = cu.Row
  7.   [g7] = Application.Count(Range("e2:e" & cu.Row)) / 3600
  8.   [h7] = Application.Sum(Range("e2:e" & cu.Row)) / 3600
  9.   Exit Sub
  10. End If
  11. Next
  12. End Sub
½Æ»s¥N½X

TOP

¦^´_ 9# owen06


    Xl0000225.rar (102.61 KB)
¦pªG¦b¦P¤@¤u§@ªí¤º¦³¨âµ§¸ê®Æ»Ý­n­Ó§OÀ˹î¨ÃÅã¥Ü¸Ó¦p¦ó?

TOP

¦^´_ 10# marklos


    ±N¤U¦C¥N½X½Æ»s¶K¤W¨ú¥N­ì¦³ªº¤º®e
  1. Private Sub CommandButton1_Click()
  2. [g5,h5,g8,h8,o5,p5,g8,h8] = ""
  3. For Each cu In Range("d2:d" & [a65536].End(3).Row)
  4. If cu.Value < [g2] Then
  5.   [g5] = cu.Offset(0, -2).Value
  6.   [h5] = cu.Row
  7.   [g8] = Application.Count(Range("e2:e" & cu.Row)) / 3600
  8.   [h8] = Application.Sum(Range("e2:e" & cu.Row)) / 3600
  9.   GoTo 99
  10. End If
  11. Next
  12. 99  For Each cu2 In Range("m2:m" & [j65536].End(3).Row)
  13. If cu2.Value < [o2] Then
  14.   [o5] = cu2.Offset(0, -2).Value
  15.   [p5] = cu2.Row
  16.   [o8] = Application.Count(Range("p2:p" & cu2.Row)) / 3600
  17.   [p8] = Application.Sum(Range("p2:p" & cu2.Row)) / 3600
  18.   Exit Sub
  19. End If
  20. Next
  21. End Sub
½Æ»s¥N½X

TOP

¦^´_ 8# owen06

­Y¥HG2 current (A) <0.15¬°°ò·Ç¡A §Ú¬O¨ú<0.15¦ý³Ì±µªñ0.15ªº²Ä¤@µ§¸ê®Æ¡A ¨º´N¬O0.149 ²Ä45¦C

§A¨úªº­È¬O 1.1494 ²Ä30¦C¡A¨ä¹ê§Ú¤]¤£¤Ó¤F¸Ñª©¤j­nªº¬O­þ¤@ºØ¡A

¨SÃö§Æ´£¨Ñ¤£¤@¼Ëªºµª®×¨Ñ°Ñ¦Ò

TOP

¦^´_ 7# marklos


¥ý¦WºÙ©w¸q
PW=OFFSET(¤u§@ªí1!$E$1,,,VALUE(¤u§@ªí1!$H$5))

¤½¦¡§ï¬°¦p¤U
=COUNT(E2:E61)/3600  --> =COUNT(PW)/3600
=SUM(E2:E61)/3600 --> =SUM(PW)/3600

TOP

·PÁ±zªº¤j¤OÀ°¦£~

TOP

¦^´_ 13# owen06


    ·PÁ±zªº¤j¤OÀ°¦£

TOP

¦^´_ 13# owen06


    ¦pªG[g8]­nÅܧ󦨭pºâ®É¶¡®t,¦p¤U~~VBA­n«ç»ò¼g~
=TEXT(g5-B2+(g5<B2),"[ss]"/3600

TOP

¦^´_ 9# owen06


    ¦pªG²Å¦X±ø¥óÁÙ­n¥[¤J³sÄò¥X²{5¦¸¥H¤W¤~¦^¶ÇSample time & Àx¦s®æ¦C¸¹ , ­n«ç»ò°µ©O?

TOP

        ÀR«ä¦Û¦b : ­ì½Ì§O¤H´N¬Oµ½«Ý¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD