date/time

Hi Team, I have tried creating 'sumx' as a measure to calculate the total talk time where the formula is "total_talk_duration" + "Inbound_duration" however the calculation does not seem to work accurately when i tried tallying. Agents total_talk_duration inbound_duration Crystal 01:09:44...

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

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

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

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

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

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

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

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

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.

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

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

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

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

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?

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

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

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

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

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