date/time

  1. D

    Some help with a last modified date/time problem

    Hi all, I'm very new to VBA and macros and am struggling to find a solution for what I would like to do. I am using some code that i found to show the date and time that a worksheet was last modified in a given cell. This does not update on it's own. The only way that I am able to update the...
  2. bobkap

    IF w/Not Equal?

    I am trying to delete columns if the header of the column is NOT a header containing the word "Transaction Status" and other headers, but when I run this (below) it doesn't delete columns based on these criteria. It deletes every column. Any help on what I'm doing wrong would be greatly...
  3. M

    Difference Between Two Dates/Times

    I am trying to figure out a way of determining how many hours and minutes have transpired between two Date/Times Cell C3 has the "Start Date/Time" and Cell D3 has the "End Date/Time" I have both of these cells formatted to display the as follows: 9/16/2019 7:30:00 AM In E3 (formatted as "Time"...
  4. R

    Convert SAP data field into Excel Date and Time

    <tbody> Need to convert following cell data by either formula or clever format number custom style CURRENT DATA IMPORTED <tbody> START FINISH hh/mm Mon Jan 08 02:20:13 AEST 2018 Mon Mar 08 09:40:17 AEST 2018 ?? imported as text, cant format number to date/time imported as text, cant...
  5. R

    Elapsed Time (h):mm:ss

    Hello, new to the forum with little knowledge of Excel. I've been searching for a formula for elapsed time showing in (h):mm:ss between to date/time Stamps i.e. Start date/time 7/10/2019 10:53 AM and finish date/time 7/10/2019 2:20 PM that will exclude weekends & holidays to no avail. I have the...
  6. F

    Macro for Filtering by Date/Time

    I'd like to add some code to an existing macro I have that will autofilter every row that contains the following criteria: today's date and after 7:00 a.m. The date/time info is populated in Column D. I don't need those rows so I will add code to delete once it's filtered, but I don't know...
  7. H

    Last Updated Worksheet Date/Time

    Hi there - I had https://www.mrexcel.com/forum/members/jmacleary.html kindly post some code a while ago. Unfortunately the code intermittently stops working. Does anyone have any ideas why? Basically the code is to update the date/time a particular range was last updated/changed. Cheers, H...
  8. S

    Formula for automatically creating a response and fix date and time

    Hi there, I need to create a spreadsheet for recording defects so that depending on the defect classification - Sev 1, Sev 2, Sev 3, Sev 4 - then an 'Expected Response Date/Time' and 'Expected Fix Date/Time' can be automatically calculated based on 'Assigned Date/Time'. The Response and Fix...
  9. P

    Convert Date/Time

    How do you convert a date/time field from UTC to EST Time zone. My time should be 1/14/2019 12:00 AM and is displaying as 1/14/2019 5:00 AM.
  10. M

    Date/Time Excel Formula Calculation Help for Intermediate user in Excel 2016

    Hello, I am trying to create a Manufacturing ProductionSchedule. I am looking for help with a formula that once given start date/time,will then calculate the end date/time. The formula for the time betweenthe start date and end date, is calculated by using the Machine/CycleTime (Kept on a...
  11. T

    Finding date/time greater than & less than, then 'get value'

    Sigh... without confusing everyone with my 'non-working' code, here's what I am attempting to do: 1) I have a WS named "Washer_S25", among many others. 2) Every sheet has a date/time column B; using the format MM/DD/YY HH:MM 2B) A userform1 posts the date & time using the Now function. 3) Using...
  12. J

    Date/Time Auto-Fill & Calculation Errors

    Hello all, I am running into what I believe to be two separate bugs in Microsoft Excel for Office 365 MSO 16.0.10730.20155 64-bit. It seems that Excel does not properly perform calculations or auto-fills properly on time/date data. I'd like to run it by you guys before I jump through the...
  13. M

    Detect date/time collisions with multiple criteria

    I have data that I am trying to determine where date/time overlap (TRUE/FALSE) works but only when certain criteria are met. The collision column is what I'd like to do via formula or macro... I'm able to find collisions using SUMPRODUCT (found plenty of examples) until I start adding...
  14. S

    re-arrange a cell that contains date/time

    Hi everyone, current cell is: 5/6/2014 7:57:24 PM would like it to be: 2014/06/05 19:57:24 is this possible?
  15. R

    time stamp

    When I enter something in to O2 I want P2 to show the date/time it was entered. I have =IF(O2<>"",IF(P2<>"",P2,NOW()),"") and it works (kinda) but I want it to update the date/time if I enter new or change the info in cell O2, it will work if I delete the info and re-enter it but I would like to...
  16. A

    MINimum Function and blank/empty cells

    I have seen references here to formulas like this =MIN(IF(A1:A3="",0,A1:A3)) What I'm doing is this =MIN(G2,I2) I want the minimum value (earliest date/time) from one cell or the other which are in date/time (mm/dd/yyyy hh:mm) format. The only issue is, it represents 2 blank cells as...
  17. T

    VBA Check if Date:Time Value is Between Other Date:Time Values

    Hi all, I am trying to write a macro that checks if a timestamp from an event falls between a series of two other time stamps. There is a timestamp in cell B2 and if it falls between the timestamps in G2 & H2, or G3 & H3, or G4 & H4 etc... I would like A2 to display "ERROR" The macro can stop...
  18. J

    date/time format with carriage returnt

    Hi, any thoughts/solution son how I can have the date/time as indicated in code below. I would like same cell to display date top line, carriage return and time below date, all same cell. The following doesn't quite do it Cells(1, "A").Value = Format(Now(), "ddmmmyy & Chr(10)HH:mm ") thanks...
  19. M

    Formula to calculate/split out hours in range

    Morning, I need a little bit of help please. Simply, I have a start date/time and an end time/date, and I need to split out the total number of hours (or decimal days) in the range so that they are apportioned to each day that they fall in: Data: A2) arrived date/time 01/02/2018 09:00...
  20. 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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top