Search:

Type: Posts; User: kelvin_9; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    15
    Views
    141

    Re: time value format

    what if i tell you not working, do you think you gonna kill me?
    deeply sorry.

    http://kel.ddns.net/f/a4c3596705/?raw=1
  2. Replies
    15
    Views
    141

    Re: time value format

    thank you so much for your solution, appreciated PCL!
    however i made a fault that what if it greater or equal, isnt it =IF((B1-INT(B1))>=($A$1-INT($A$1)),TRUE,FALSE)
  3. Replies
    15
    Views
    141

    Re: time value format

    time enter by me, even i enter 21:00, it's still not working fine
    as i said, i have manual change both format cell as "hh:mm"

    p.s. the file entered time 21:00 and tested again
  4. Replies
    15
    Views
    141

    Re: time value format

    http://kel.ddns.net/f/a4c3596705/?raw=1

    i might have sth wrong i'm sorry
    even A1 is empty, B1 still colored.

    column B is lookup from database to return the last time of my employee clock out...
  5. Replies
    15
    Views
    141

    Re: time value format

    which cell should i use this formula?
  6. Replies
    15
    Views
    141

    Re: time value format

    i tried this in conditional formatting, it doesn't work? time format issue?
  7. Replies
    15
    Views
    141

    time value format

    hi all, i would like to ask how can i amend my issue.

    A1 is used to enter a time to color B1:B100 by conditional formatting which is greater than A1
    i've manual changed the format both are...
  8. Replies
    5
    Views
    137

    Re: conditional formatting with time format

    it's good now, i messed sth, i am sorry.
    thanks james in advance
  9. Replies
    5
    Views
    137

    Re: conditional formatting with time format

    thanks james
    am i wrong?
    http://kel.ddns.net/f/60b6db6dbe/?raw=1
  10. Replies
    5
    Views
    137

    conditional formatting with time format

    hi all,
    if i want to enter a time with format([$-en-US,1]hh:mm) in A1, how can i easily track in column B, if time is larger than A1, bold/color the cell automatically?

    thanks
  11. Replies
    0
    Views
    33

    vlookup time format

    Hi all, i have a question on time format when vlookup.
    how can i easier to identify (conditional formatting with color or vlookup to return with my request only?) the table below if i want greater...
  12. Replies
    6
    Views
    87

    Re: if+index+match

    wooo~~
    any ideas to avoid similar like this but still can return a correct one?
  13. Replies
    6
    Views
    87

    Re: if+index+match

    =IF(INDEX(SCHEDULE!$C:$C,MATCH(RESULT!$A51,SCHEDULE!$A:$A,0))="","",TEXT(MIN(IFERROR(TIMEVALUE(LEFT(INDEX(SCHEDULE!$C:$C,MATCH(RESULT!$A51,SCHEDULE!$A:$A,0)):INDEX(SCHEDULE!$C:$C,MATCH(RESULT!$A52,SCH...
  14. Replies
    6
    Views
    87

    Re: if+index+match

    this may not cure?
    i have others employee which has 2-3 more duration instead
    i dont know where is/are my problem. :confused:

    my formula is used to take the first and the last time if more than...
  15. Thread: if+and

    by kelvin_9
    Replies
    4
    Views
    124

    Re: if+and

    works prefect, thanks MARK858:rolleyes:
  16. Replies
    6
    Views
    87

    if+index+match

    hi all, any idea on what's wrong with my formula below, i cant return Khloe Kung result same as others user with same formula.?
    what should i amend and fix my issue?

    thanks all
    ...
  17. Thread: if+and

    by kelvin_9
    Replies
    4
    Views
    124

    Re: if+and

    i apologize for the confuse, MARK858
    i use it to return my result like this:


    <tbody>
    column B
    column C
    Column D
  18. Thread: if+and

    by kelvin_9
    Replies
    4
    Views
    124

    if+and

    hello all, i need hand on a IF+AND formula, how can i amend it with my request?


    =IFERROR(IF(AND(--LEFT(C59,5)>=--LEFT(B59,5),--RIGHT(C59,5)<=--RIGHT(B59,5)),"","WRONG"),"")

    is it possible to...
  19. Replies
    3
    Views
    130

    Re: spliting the array formula

    no one know?:-(
  20. Replies
    3
    Views
    130

    Re: spliting the array formula

    anyone know?:eeek:
  21. Replies
    3
    Views
    130

    Re: spliting the array formula

    Sub Test()Dim rDate As Range, rDest As RangeDim sText1 As String, sText2, sText3 As String


    Set rDate = Range("a1")
    Set rDest = Range("a2")


    sText1 =...
  22. Replies
    3
    Views
    130

    spliting the array formula

    i was amended a formula here and planning to run in macro, but i got stuck
    is it mean one more range need to assign to run the new formula?


    Sub Macro003()'
    ' Macro003 Macro
    '
  23. Thread: If+index

    by kelvin_9
    Replies
    5
    Views
    190

    Re: If+index

    thanks man, it's really fantasic

    with character limitation of macro
    is it mean one more range need to assign to run the new formula?


    Sub Macro003()'
    ' Macro003 Macro
    '
  24. Thread: If+index

    by kelvin_9
    Replies
    5
    Views
    190

    Re: If+index

    is it impossible to do it as my formula is too many requirement:confused:
  25. Thread: If+index

    by kelvin_9
    Replies
    5
    Views
    190

    Re: If+index

    any help
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4