date and time difference

My new position at work has me doing a lot of spreadsheet analysis. I love it, but realize I have to ramp up big time to learn how to do a bunch of excel how-to functions. I have a 15 year background of writing Visual Basic EXE applications, and told I can use a lot of that experience via VBA...

I inherited an Excel 2010 workbook that is utilized to import in another excel data feed that is extracted from online source daily. Once imported this .xlsm workbook does several things, custom columns, several sorts, conditional formatting, etc. It currently highlights all rows that have a...

I inherited an Excel 2010 workbook that is utilized to import in another excel data feed that is extracted from online source daily. Once imported this .xlsm workbook does several things, custom columns, several sorts, conditional formatting, etc. It currently highlights all rows that have a...

Hi I'm having problems with the following formula: <tbody> A B C Date Opened Date Closed Total days to closeout 26/07/2013 13/08/2013 18 26/07/2013 19/08/2013 24 31/07/2013 -41486 01/08/2013 -41487 </tbody> I want to copy the following formula in Column C all the way...

A1 = 12/30/2012 B1 = 12/30/2012 B2 = 1/5/2013 Can someone tell me why 01/05/2013 is not larger then 12/30/2012? code DateOne = Format(Range("A1"), "mm/dd/yyyy" DateTwo = Format(Range("B1"), "mm/dd/yyyy" DateThr = Format(Range("B2"), "mm/dd/yyyy" Chk1 = DateOne <= DateTwo Chk2 = DateThr >...

Hi I have data showing when staff arrive at, enter after clearing security and then exit a building after completing their task. The data for each cell is a combined date and time as opposed to separate cells for date and time. I am trying to ascertain how long our security staff take to clear...

Hello everyone. I have a pivot table that has two columns that contain dates. I am trying to add a column with a OR formula that returns true or false base on whether the first date is equal to the second date OR the first date +1 equals the second date. The formuala I use is...

Hi.. Can some one help me to solve the below problem? I have Column A = Start Date (mm/dd/yy), Column B = Start time (hh:mm:ss AM/PM) and Column C = End Date (mm/dd/yy), Column D = End time (hh:mm:ss AM/PM). Now in Column E, I would like to have "Yes" if End time is <= 6 hours from the start...

Hi everyone! I’m working with a process chain that includes several dates. <o:p></o:p> <o:p></o:p> Explanation of Cells:<o:p></o:p> A1: Date for Initial Review (Should not take more than four days to escalate)<o:p></o:p> B1: Contains formula to determine whether timeframe of A1 is “OVER” or...

<tbody> A B C Here is what i need 1 Date # of hours Start Date____i want to enter any day 2 1/1/12 0 # of hours_____enter any number of hours 3 1/2/12 6 End Date______need a return date 4 1/3/12 6 so if i enter 1/2/12 as enter date 5 1/4/12 6 and 24 hours 6 1/5/12 0 i need the end...

I need to create a comparison of MTD, YTD, and a 3 month Comparison in Excel 2007 using the current date (mm). I do not want to have to change a number to signify the month. The Data is laid out like this: <TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0...

i'm trying to create a formula which calculates number of weeks into the quarter. for example, the quarter starts 1/26/2011 Q1 4/26/2011 Q2 7/26/2011 Q3 10/26/2011 Q4 and based on today's date, it would tell me how many weeks i'm into the Q...

Hi I need a formula to calculate the business hours taken to complete a job. The job runs over a few days but only during business hours. I have calculated the time difference by subtracting the the 2nd date time from the 1st but that gives me total hours, i need just the business hours...

Hi- I have a spreadsheet that has the following columns (in addition to others): Request Date: 04/12/2011 Request Hr: 9:19:40 AM Decision Date: 04/13/2011 Decision Hr: 8:03:06 AM I have another column that determines the number of calendar days between the two date fields. When the # of...