Search results

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

please see example of outputs from very large formula

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

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

works perfect thanks

I tried this and it will not work sorry getting this

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

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

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

now get the following error?

thank you very much

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...

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

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

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

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...

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...

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...

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...

your assumption is correct thank you very much

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

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

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

sorted it , not ; thanks