date/time

I'm sure this is simple, but I am stuck... I am using the following formula: =IFERROR(TEXT(D7-C7, "[h]:mm:ss"),"") This works great in preventing the "#Value!" errors I get when "D" doesn't have a date/time. The issue is that when neither cell has a date/time it returns 0:00:00...is there a...

I am having trouble finding the 'split date' between 2 dates/times. My data does not export together, meaning I have a date field, time field, date field, time field. Example: From Date From Time To Date To Time so I used "=a1+b1" and the same for the next columns. Now...

Hi All, I need some help from all of you geniuses. I'd like to utilize a macro to delete rows in a spreadsheet based on a repeating set of formats. In the table below, the macro would need to start deleting at the first empty row (2) and finish with deleting the last row "Date/Time...

Hello all, I'm using the following code to put a Date/Time in some cells: Public Const TargetSht As String = "Info" Sheets(TargetSht).Range("J10").Value = Format(Now, "DD-MM-YY HH:MM") For yesterday, the result of this code is: 04-12-18 12:00 while according to our standards (I'm from the...

Hi, Is there a formula that will make Access recognize a date and time formatted as text as a Access Date/Time field? A lot of times I have wonky source data and bring in dates/times as text when I import to avoid paste errors related to those fields. Then I format them as dates/times through...

I’ve been struggling with how to start and get this done. I have a column that contains a length of time that could be worded like: 53 seconds ago, 2 hours ago, 1 minute ago. Then I have a column that has the date/time the data was extracted. I need to be able to subtract the column that has...

Col A - has date/time in 15 min increments throughout work day Col D - has various work tasks How can I avg the amount of time it takes to complete a task per day? Thank you for any help and please let me know if I can provide further clarification. <colgroup><col width="113" style="width...

Hi all, I'm creating a timesheet entry system that will log the date/time and either IN or OUT when a button is clicked. I have the code to log the date/time, but was looking for help entering an alternating IN/OUT text? For example, if it is the first entry, I'd like A4 to display "IN". On...

I have 2 sets of date/time data I need to compare. Scheduled date/time Worked date/time Both the scheduled and worked data can have multiple entries throughout the day. How can I compare these two data sets?

Hello I'm trying to subtract a date/time in m/d/yyyy h:mm format from the current date/time. I have the following formula : =IFERROR(INT(NOW()-A1)&" days " & TEXT(NOW()-A1,"h""hrs ""m""mins"""),"") If the current date/time is 1/24/2018 8:51 and the date in A1 is 1/23/2018 1:20, the formula...

I’m self-taught in MS Access and haven’t done much with 2010 since I learned a long time ago in 2003. So please don’t hesitate to be explicit I have thick skin and can use the direct guidance. I have a table that contains all the data for the dates in which a person is to be paid out there...

I am trying to figure out how get a false result for “Hotel” if “Air”, “Stop”, “Car”, or “Rail” are FALSE for the traveler and location. The below traveler evaluates FALSE for “Air” and “Stop”, and TRUE for “Hotel”, because of the formula I am using. The other issue is, not all travelers have...

How can i calculate how many minutes between dates & times. These dates and times can be in the same day or they can spread over multiple days Example: 1st entered date/time is in cell B4 (22/11/2017 7:34:00 am) & 2nd entered date/time is in cell B5 (23/11/2017 10:34). The formula or VBA would...

Hello learned folk. I have been given large files with a consistent format for the date/time of an observation as follows: " 08.03.2008, 23:00:00.000". There are thousands of date/times in a single column and what I want to do is calculate the time interval between successive observations. As it...

Hello, I am trying to create a "DateAdded" field to my spreadsheet. What I would like to be able to happen is that once values are populated in columns A,B,C,D,E and H of a row to have the current date/time in Column BV Is this possible? I am suspecting that it would involve VBA but not...

I calculate MTR of service requests by subtracting the close date/time from the create date/time But is there a way of also factoring out weekends and possibly national holidays in that equation?

I already posted yesterday in the Excel Forum with this problem, but have not received a reply yet so I hope someone here might have some ideas on how to go about solving this. I have a large set of data for the dates and times when a vehicle is parked. e.g. the start date/time is 07/10/2016...

Hi All, I'm new to the forum and to the macro world. Here is what I'm trying to do: I have a datastream that consists of 23 datapoints/tag ID's that are logged on one minute intervals (see "Source Data") I would like to write a macro that select this data, sort it by date/time in ascending...

Okay... I have a database that multiple users access on the network. I do not have it split and it is too late to deal with that. Moving on... I have been manually looking in the table to try to track data changes but it is too hard now so I decided to add date/time stamps to the records to...

I have a sheet which shows date in first column then every 15min to the columns to the right (96 columns). This makes one row per day. I would like to get this sheet which has 365 rows for the year to display in two columns. First date/time, second is value. This would reformat the existing...