date and time difference

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

I am trying to write a macro that will compare 2 cells, then will take the dates corresponding to those cells and tell me the amount of week days between the 2 dates. The part I'm having trouble with is the IF i wrote Sub DateCalculation() ' ' DateCalculation Macro ' ' Keyboard Shortcut...

Hi All, I am working with bar codes of products. Any bar code repeated in specific period is considered redo. For this I have created 4 helper columns which are somewhat fulfilling the need. But I still need to read whole description of work done to specify if it is redo or not. What I am...

I have a range of dates in column A and I only need to identify the dates within the last 2 years. Is there a way to use conditional formatting to only highlight the dates that are within the last 2 years? Thanks in advance!

Hi, I need help. I want to subtract 2 columns from each other (Dates) but the cells need to be checked fist if blank and if blank it should ignore the one or use Today() in the other. Example below. Row 4 and 5 work but row 6 gives me a 43027 value that should be a blank as I get the average...

I have two date. I want to count number of days between. Dim date_today, test_date As Date Dim result as Long date_today = Format(Now(), "dd/mm/yyyy") test_date = Format(wsM.Range("M10").Value, "dd/mm/yyyy") result= DateDiff("D", date_today, test_date) But the result is wrong, it's 539...

Hi to all professionals :) Need your professional help to put the below query in to excel formula please. Basically i have two dates on the left of the table, which is input from user, i need to calculate the number of days between period split mentioned on the right of the below table...

example: Mon Oct 10 00:00:01 PDT 2016 and Mon Oct 10 00:00:42 PDT 2016 what is the formula to calculate the duration between these two values? any help would be great

Columns("U:U").Select Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("U1").Value = "Data" Range("U2").Select ActiveCell.FormulaR1C1 = "=DATE(Month(TODAY())&Date(TODAY()-20)& &LOW&L2&_INV&S2" Selection.AutoFill...

Hello all! Stuck on a problem. I have a spreadsheet which contains information about when a website outage occurred. Each row is an outage incident. I can calculate the total duration of the outage. I have a "start of outage" and a "end of outage" timestamp, format 3/10/16 16:30:00. With the...

Hi all, I have seen many questions have already been asked regarding calculating leadtimes and related topics, but I was not able to find the answer to my specific question. Therefore I am opening a new thread. I f my question has already been posed and answered, i apologize and kindly ask you...

I regularly have to manually review large volumes of excel data, one column being the date by which the data is ordered. For visual convenience, every time the month changes (e.g. from August to September), I increase the row height so as to visually group the data. The data is provided by...

Hello, i have a a problem when i try to reach the number of days there are between 2 dates, my code is : 'COMPLETED Range("D3").Select Do While ActiveCell <> Empty ActiveCell.Offset(1, 0).Select Loop ActiveCell.Value = CLng(date) - CLng(List_Projet(id_P).date_debut_P) 'REMAINING...

I am very new to VBA and am teaching myself as I go. The one thing I need but cannot figure out is: I have a spreadsheet. Each day user fills out a userform to input data as needed (around 50 inputs). The code once the user clicks "Submit" on the userform takes all of that data and places it...

I'd like to request help in converting the following formula to DAX/PowerPivot: =(NETWORKDAYS(B2,A2)-2)*0.375+MOD(A2,1)-"09:00"+"18:00"-MOD(B2,1) it would also be great if you could help me determine how to deal with changes in the hours of operation. I have also not yet figured out how to...

Hello, I am stumped how to write a formula that takes a cell with a value formatted as Date & Time and another cell with a value formatted as Date and Time and returns a result that is the qty of 1/3 days in the period between the two times. Any portion of a third should count as a full third...

Please help me write this code. Thanks!! Ask the user to enter date. If the user enters date between January – May Display: “Online Class Only!” If the user enters date between June – July Display: “No class available!” If the user enters date between August – November Display: “Two...

I have been bashing my head against this problem for a few hours and just when I thought I'd cracked it running some validation against the formula showed it adds up 1 year as 364 days so I have just shifted my problem. In short I have two dates 02/11/2013 and 04/06/2014 and I need a formula to...

Hello, I want to calculate the difference in months between two dates. For example, in cell B2, I have 12/31/2014. In cell A2, I have A2, I have 5/3/2014. The days of the month will vary, so this may be messy. What I'm looking for is a calculation that will tell me that there would be 7...

Hi I have an excel problem that I have a hard time solving. Assume having a couple of date intervals: from to 2012-08-01 2014-07-31 2013-04-05 2014-07-31 How do I count how many days in say april 2013 does the two intervals above "cover". Is there a formula that...