time & date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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