• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    Extract the time and date from a data extraction

    Not yet I posted an example of current workbook called Opus trigger times
  2. T

    Extract the time and date from a data extraction

    please see example of outputs from very large formula
  3. T

    Extract the time and date from a data extraction

    Thanks for the rely but the trans time is digital I think so 105514 is not 10:55:14
  4. T

    Extract the time and date from a data extraction

    Hello I have an extraction from a system and am trying to put a date and time in the column to the left looked at loads of info on the web but cant find anything relating to the TRAN_TIME format? Any help is appreciated I have added the spreadsheet
  5. T

    Working with Early and late arrivals

    works perfect thanks
  6. T

    Working with Early and late arrivals

    I tried this and it will not work sorry getting this
  7. T

    Working with Early and late arrivals

    I did have it simplified but when a truck arrives past midnight it shows early ie 23:55 expected time but arrives at 00:15 shows early thanks
  8. T

    Working with Early and late arrivals

    Hi 23:30 needs to populate "Early" although it is in fact On Time thanks
  9. T

    Working with Early and late arrivals

    Hello I have a formula =IF(OR(J4="",I4=J4),"",IF(0>((MOD(J4-I4,1)>0.5)-MOD(J4-I4,1)),"LATE","EARLY")) if the vehicle arrives on time ie 23:30 the cell shows blank instead of Early how can I stop this happening please its driving me mad
  10. T

    Date and time insertion from data put in a cell

    now get the following error?
  11. T

    Date and time insertion from data put in a cell

    thank you very much
  12. T

    Date and time insertion from data put in a cell

    Hello i would like the date and time inserted into a cell the same as below,, the code below populates the date and time when cell "S" has data entered into it. Private Sub Worksheet_Change(ByVal Target As Range) Dim rInt As Range Dim rCell As Range Dim tCell As Range Set...
  13. T

    Compile error in vBA using 64 bit

    thanks Chihiro i will take a look bast regards ▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !
  14. T

    Compile error in vBA using 64 bit

    i am now getting a message saying i cannot run VBA would anybody know if this is an easy fix please
  15. T

    times past midnight not working properly

    i have sorted it may i take this opportunity to say thank you very much for all your help
  16. T

    times past midnight not working properly

    Hi iv been playing around with this for a few days still not coming out right I will have another go tomorrow, thanks for your help its appreciated. I will try and put a validation field in the input column i.e. dd/mm/yyyy hh:mm would that work? I will post the whole document up with real data...
  17. T

    times past midnight not working properly

    point 1 can be done via formula, once the conversation is taken place it will be cut and pasted into the first tab (A:H) point 2 can be done by a helper column after column H as this would not interfere with pasting part? I do agree with you about dd/mm/yy/ hh:ss it would make it so much easier...
  18. T

    times past midnight not working properly

    hi the data from qrysubbytracker_xls needs to be copied daily into the Late collections sheet on the first tab (A:H) the data in the qrysubbytracker_xls need to have the duplicates taking out using the trip id as the unique key column (E) the data that's left needs to be copied into the first...
  19. T

    times past midnight not working properly

    Hi Chihiro i am having difficulty when pasting the data in the sheet I have attached the sheet the data is copied from the red tab into the green tab, the problem I am having is the data extract is not formatted you can see that all data is showing as "general", I also have to remove the...
  20. T

    times past midnight not working properly

    your assumption is correct thank you very much
  21. T

    times past midnight not working properly

    ok i can see that do you have any other ideas? sometimes the do arrive earlier i am going to put a pivot table on the back of this so if there was another column showing early that would be great thanks
  22. T

    times past midnight not working properly

    thanks for the quick reply Chihiro most appreciated i have just discovered a flaw if they turn up before booked time it shows up in the [TO BE INCLUDED +60 MIN] how would i show another column showing early =1 please
  23. T

    times past midnight not working properly

    Good evening i have a sheet i have been working on for sometime now and i cannot figure out how to show the correct times passed midnight column e for row 4 should show -00:20 and same with column e row 5 that should show -01:00 can anybody help please
  24. T

    trigger times

    sorted it , not ; thanks
Back
Top