time & date

  1. S

    Calculate machine hours excluding weekends or non-operational hours

    Hi, I am having a hard time figuring out a formula in this case. Here, 29th October is a Friday and 01st November is a Monday. Our Machine stops operating at 10:30pm on Friday and starts on 31st October Sunday Night 9:30pm. I need some help to figure this out. Time between pan loads will be...
  2. J

    Calculating time difference per task over 2 days

    Hi, I am trying to figure out how to find the difference between two task times as long as their ID number is the same. This is for different shifts/days so when their shifts ends at 3AM and starts back at 4PM the next day I don't want to take the 12 hour time difference - I want it to say 0. I...
  3. P

    Create static timestamp using VBA macro and data validation input

    Hello I have only just started using this forum and I could really use some help. I am trying to create static timestamps in one column range "R" (R4:R56), dependent on/using a date entered in an adjacent column range "Q" (Q4:Q56) and data validation input in R. Using the data validation input...
  4. M

    Track users login and logout time / day

    Hi all, I need your help please. I need users to enter username and password in order to open and edit an excel file and to keep login and logout time. Using an extra excel file or worksheet in order to collect usernames and passwords is ok, as I just need that to have knowledge. I know that...
  5. M

    Comments - Time & Date Stamp

    Hi, If someone can help me find a way to remove or hide the time and date stamp from 'comments' in Excel 365, it will be much appreciated. I am using the comments function to add regular updates to individual items in a workbook and am applying a date against each update in the comments field...
  6. A

    Dealing with Time Values

    Hi, would someone please help me understand why my column "G" that has a custom value set to "h:mm:ss" has a VarType of double? I am trying to filter for rows that fall between my start hour and end hour, but I cant seem to get the types to match. Looking at a cell value in column "G", it shows...
  7. L

    Adding Hours Based on Time Zone

    Hi All, I am having some trouble adjusting the hours based on Time Zone. For context, I have a dataset where the date / time in column AC is all in EST. I want to adjust this based on Time Zone. In column AK I used =TIME(HOUR(AC2),0,0) to pull out the hour + AM / PM. However, I want to adjust...
  8. I

    Need help to sum live data in 2 week increments.

    My goal is to understand which two week increments of a marketing campaign were most/least effective. Column A: live data for a marketing campaign (leads generated) Column B: Sum up the live data up until 2 weeks after the start date of the campaign. After the 2 weeks is complete, I would...
  9. D

    Split Time Range into Half Hour Each Row

    I have a data set that look like this Name Activity Detail Start Finish Bob Cooking Cooking pasta 22/04/2020 9:00 22/04/2020 10:00 Bill Reading Reading novel 22/04/2020 9:30 22/04/2020 10:00 And i want to split it like this Name Time Activity Detail Bob 22/04/2020 9:00 Cooking...
  10. S

    Check if the in and out time falls between a specific time interval

    I am looking for a solution after a long trial and error workings. I have 2 columns in and out with date and time. I want to check if the in and out falls between the interval 10PM to 8AM of next day. Further, for those which falls within this range, I want to check atleast minimum of 3 hours...
  11. W

    Time and Date task scheduling for a 2 shift operation

    This is a small part of a larger project. I am not a VBA person so please keep that in mind. I am trying to develop a task level schedule planner for a 2 shift 10 hour per shift operation. I have a list of task with start date, duration and a calculated end date based on the duration. All...
  12. O

    Julian to Gregorian VBA

    I am attempting to solve a problem of finding the difference between two times. The times are downloaded and displayed in a single cell i.e. "8363/0031". The first 4 numbers is the Julian Date and the last 4 are hhmm in 24 hour format. I need to subtract one cell from another and display the...
  13. R

    Comparing times with different text formats

    Hi I am trying to compare two lots of times and got as far as the code below. In Cells A1, A2 and A3 I have three times in the format +02'00... and in Cells B1, B2, B3 I have three times in the format 00:17:00. If the time in Column A are greater than the times in Column B I want a Yes in...
  14. G

    find the connecting flights based on criteria

    Hi all, I have been struggling with the following for a number of days now. I want to be able to retrieve the flights that can be connected with Y flight. Basically.. I have Flight nr AA0001 "Y" and based on a departure and arrival list and the minimum connecting time, i want to see which "X"...
  15. D

    In a Time Formula convert into Whole Number in same cell formula Struggling

    HI Guys Please see attached image re problem I have question written on image I have added the Spreadsheet here as well PLease can you help
  16. G

    Converting raw data to pivot table/chart doesn't detect seconds

    Hey! I'm in a bit of a pickle. So basically, I've got over 50,000 lines of columns that I have to convert to charts. And to test it out, I used a pivot table and chart. Everything works fine, but it doesn't detect seconds. So, what I did was: In raw data convert the text to columns as DATE...
  17. L

    "Challenge" Time Calculation

    Dear Masters, I have a real challenge to you, I need formula or VBA that calculate the column 10 PM to 5 AM and10 PM to End. The formula or VBA need to understand: Column “10 PM to 5 AM” Calculate just time between 10 PM until 5 AM (number in hours, can be hours and minutes) Column “10...
  18. J

    Work Schedule with lunch breaks if over 8hrs

    I have a worksheet set up as a schedule for 8 people, for the entire month. Z6 & Y6 have the start time & end time of this persons shift on a specific date (if they are not working it's left blank). If there are work times in the cells, I want it to subtract the end time from the start time...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top