date/time

  1. L

    Format_Text Formula Help

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

    date/time difference

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

    Macro help (delete rows based on row value)

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

    [VBA] Date/Time in cell in wrong format despite FORMAT() function.

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

    access date and time formatted as text - formula to convert it to an actual date/time field when run as a MakeTable?

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

    Extract length of time and subtract from date/time cell value

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

    Calculate avg time to complete task

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

    VBA to enter alternating text

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

    Compare Two Time Ranges

    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?
  10. C

    Subtracting Dates

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

    Query single user defined paramter against multiple columns

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

    Compare Multiple Criteria to get a TRUE/FALSE result

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

    working out minutes between times

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

    time intervals

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

    Populating fields based on action

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

    Using networkdays - holidays

    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?
  17. W

    How to split rows by date and time?

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

    Sort by date/time, copy, & paste special (transpose)

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

    Date/Time stamp in table.

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

    wide sheet reformat

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top