time and date

Hopefully someone can give me a hand with this one as I've been stuck for a few hours now trying to get this done correctly. I have 3 columns that I'm trying to get a dropdown that displays the current system time and allows me to once clicked autopopulate into the selected cell within the...

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