Recent content by thesilkster

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