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