1. B

    Calculate total hh:mm in BI

    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...
  2. 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...
  3. 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...
  4. 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"...
  5. 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...
  6. 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...
  7. 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...
  8. H

    Last Updated Worksheet Date/Time

    Hi there - I had 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...
  9. 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...
  10. 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.
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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?
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

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