Results 1 to 8 of 8

How to use the SUM formula to subtract and calculate time elapsed from mm/dd/yy hh:mm cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2023
    Location
    USA
    MS-Off Ver
    Office365
    Posts
    7

    How to use the SUM formula to subtract and calculate time elapsed from mm/dd/yy hh:mm cell

    How do I properly use the SUM formula to subtract and calculate time elapsed from mm/dd/yy hh:mm cells?

    Example I'm trying to achieve:
    Cell A1: 9/27/23 4:15 PM
    Cell B1: 9/27/23 4:27 PM
    Cell C1: =SUM(B1-A1) to show 00:12
    Cell D1: =IF(D1>00:15,NO,YES) to show YES

    I've been trying to throw different SUM formulas and custom formatting and this and that, but cannot for the life of me get it to work. I think Office365 web is partially the problem, but perhaps there is something at play.

    During the process of trial and error, I've managed to get outputs to show "-4325.4"2 type output or "#######" with no actual numbers. I tried formatting the cell various ways and can't get it to work. Please help.

    After getting the correct output going I'm going to throw an IF formula in D1 "=IF(C1>00:15,NO,YES)" to see what tickets are meeting SLA response times.

    Update: In the process of adding a sample file, I got =SUM and =SUMPRODUCT formulas to work in two of the cells as samples, but the math is incorrect. Looking forward to learn something about this situation. Thanks a bunch.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by J3RM; 10-03-2023 at 05:48 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Formula to calculate elapsed time between two dates/time in Google Sheets
    By bhenlee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-12-2023, 05:13 AM
  2. [SOLVED] SUMPRODUCT Formula to Calculate Elapsed Time
    By sorensjp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-27-2022, 10:59 AM
  3. Formula to Calculate Current Time Elapsed
    By kschmit1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2017, 02:33 PM
  4. [SOLVED] How to subtract Time Values contained in Labels on a userform - Time Elapsed Live Clock
    By deadeye_draken in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-18-2017, 06:44 AM
  5. Replies: 2
    Last Post: 04-27-2011, 08:21 AM
  6. [SOLVED] Ref: Formula to calculate elapsed time between certain dates and t
    By DrBarqs in forum Excel General
    Replies: 2
    Last Post: 11-18-2005, 07:20 PM
  7. [SOLVED] Formula to calculate elapsed time between certain dates and times
    By Stadinx in forum Excel General
    Replies: 6
    Last Post: 03-25-2005, 03:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1