time and date

Thanks for looking the code below is what Im currently using. I need to modify this so it does not look in the entire row. Example: instead of it looking in column 3 and 20 i need to look at column 3 and 20 down to row 25 starting with row 4. Private Sub Worksheet_Change(ByVal Target As...

Hi, I need to calculate an SLA. I have 1 column called 'Date/Time Requested' containing the time and the date together, as in: dd/mm/yy hh:00 I also have a second column called 'Date/Time Completed' containing the date and time in the same format as above. I need a macro that compares...

Hi All, This is me: :confused: :eeek: :mad: :( I apologise if this has been asked already but I am so lost on the lingo I wouldn't have a clue. I have done a VBA course but am struggling to apply it to my situation. What I want to do is on one spreadsheet, I have a column with "shift...

Hello, I am working with some drivetime data and the data is the time format (eg 13:30). One hour and 6 mins is represented by 1:06:00 AM, 20 mins is represented by 12:20:00 AM, etc. I want to sort the list so I can look at things like how many commutes are greater than 1 hour but sort does...

Is there a formula to acheive the following: If I have these transactions: Cell <TABLE style="WIDTH: 131pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=175><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt...