time interval

Hello all, I am working on a spreadsheet to determine flight windows. We are trying to make a spreadsheet calculate the time window between scheduled aircraft ARR (arrivals) & DEP (departures). I will be inputting the times in as 24-hr hours/minutes. When the aircraft is a departure we need...

Hi, I've worked all weekend to learn VBA. I came close, but code is probably what a proper coder would call (very) ugly. I would really appreciate tips on how to make a more streamlined code in addition to the key question: A rather big set of data are collected on sheet 1 ("Disorderly"). Column...

I HAVE TIME FROM DATE FIELD LIKE 15:44, i WANT TO CHECK IF IT FALLS BETWEEN 10 am TO 8 pm OR (10 TO 22 ) tried few things from earlier posts but not working : ( It shoud say 1 if true, 0 if not any pointers help will be appreciated

Hi, Please assist. I am looking to write a VBA code. I have a column named "target date" in mm/dd/yyyy 12 hour(AM/PM) format. for example 9/29/2015 5:20 pm. I want to calculate the difference in hh:mm between "now"-"target date", excluding weekends. i want the resulting difference in hh:mm...

I have a list of 45 employees. I am allowed to export their time punches. Normally four punches per day, sometimes two punches. I would like to make a formula that tells me how many hours an employee worked, I would also like to see who has taken a break that is greater than 30 minutes. The...