date & time

I have a large data table that was not very well put together. I need to find the last test date a student took a specific test in a range that contains also contains dates for the other tests they've taken. My table is as such: ID | LName | Test Date | Math Test | Score | Eng Test | Score |...

I have an excel workbook with a worksheet that has 78 columns of data (a lot I know) and was looking for a way to add a date/timestamp to each field so that I can filter and find when a field was changed in this large data set. I found the below code here, and it works really well however, it...

I am trying to merge 4 date and time cells together into 1 cell. I am using the following formula: =CONCATENATE(TEXT(Table_query__42[@[Soft Lock 1 End]],"mm/dd/yyyy h:mm AM/PM"), "; ",TEXT(Table_query__42[@[Soft Lock 1 Start]], "mm/dd/yyy h:mm AM/PM"), "; ",TEXT(Table_query__42[@[Soft Lock 2...

I'm not able to calculate the date (accurately) I should run out of an item using the formula: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #003ecc}span.s2 {color: #005109}</style>=TODAY()+N2 where the values in...

Hi, I have a storm report that we have been running since 2/1/19 that basically tracks the number of incidents that occur each day. This is a sample from the report (top row is the column they are in): <tbody> G M T U Date Time frame Month Blue Sky / Storm <tbody> 2/1/2019 09:50:14...

Hi, So I was hoping someone could help me out with formulas. i have some data and I would like a formula that can show me if data offsets between two accounts. So I have the below data: <tbody> (A)date/time (B)product (C)amount (D)Buy/Sell (E)price (F)account (G)amount offset? 6/3/2019...

Hi! Our biometrics had a glitch and I have to manually check the data extracted from the machine. There are multiple logs in a day from different people. I would like to know the formula to get the First In and Last Out per person per day. I initially concatenated the employee number and dates...

Hi, I need to know the total minutes between ARRIVE DATE / ARRIVE TIME and DEPART DATE / DEPART TIME. Times are in 24hr format. Can someone show me how to update TOTAL MINS as data is entered please. Thank you. <colgroup><col width="64" style="width:48pt" span="9"> </colgroup><tbody>...

I am looking for a macro that will enter the current date and time in one cell so that it will not change from the time entered. I see that I can enter Ctrl+; [Space] Ctrl+Shift+; but I am looking for a way to assign that to one key combination.

Hi all, So i have a long column of date data (01/10/2018 etc) in Column A:A and what I'm trying to do is have Column B:B return back the following criteria: Last Week (Which is the date in A:A is in the last 7 days) Last Week -1 (Date in A:A is from the week prior to last) Last Week -2 etc...

I have a list of times which were bought over as Text, so the date is 01/01/1900. I want to update the date to todays date. Tried this: =DAY(H2)+MONTH(H2)+YEAR(H2)+HOUR(A9)+MINUTE(A9)+SECOND(A9) which gives me a 1905 year date As well as...

Hello, I have two columns of dates as shown in the below table: <tbody> 5/1/2016 01:00 5/1/2016 01:00 yes 5/1/2016 02:00 5/1/2016 04:00 yes 5/1/2016 02:00 6/1/2016 05:00 yes 5/1/2016 03:00 7/2/2016 10:00 no 5/1/2016 04:00 8/2/2016 05:00 yes 5/1/2016 05:00 9/3/2016 05:00 no...

Hi, I am trying to make a formula that take a certain period of time (M-1, M0, M1, M2, M3 and M4) So the previous month and 5 month ahead. I made a similar code for the past 6 month...

Hello, I have a table like bellow. How can I use excel formula functions to have another column/columns that puts corresponding "Course" name/names if there is/are overlap/overlaps? Thank you <colgroup><col width="64" style="width: 48pt;" span="5"> <col width="78" style="width: 58pt...

Hi People. I want to enter a value into a combo box on a webpage. I can access the combo box no problem and enter a value. ... my issue is the value is a date and needs to be entered in a certain format which is dd-mm-yy. However as this range changes on a daily basis i cannot put...

Hi all, I'm improving a macro and want to save the file according to the current naming conventions used. The files report numbers used for the current day and the day before, so the file names take the form "REVIEWED_07172018_07182018_TQREPORT.xlsx". I can get today's date into the string...

So I am working on a project to automate the pull of data from my companies website. I have figured out how to do the majority of the project; I am having trouble when I have to name the new sheet to write the data to. my code is as follows.. With y.Sheets("Sheet1").Range("A1")...

Hi, I am awful with formula's that relate to dates, this should be an easy request. I want to say if cell a (example) is equal to the month in cell b (this is in date format so 01/06/2018, for june) then display the date six months ago (01/01/2018). thanks in advance

Hi, I would like to write an If Formula (think combines vlookup too) I would like to say if todays today is displayed in x field return the value in y field, if not repeat the formula for yesterday date so like today()-1 etc and repeat this for 2,3 todays.

Dear Friends, I tried to make Date without weekend with time, but I could not make correctly. Kindly some one help me. This is what I expect. This is what I get :( Kind Regards