+ Reply to Thread
Results 1 to 2 of 2

Time calculations subtraction and average

  1. #1
    Registered User
    Join Date
    12-10-2013
    Location
    SOUTH CAROLINA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Time calculations subtraction and average

    ok folk I'm new here, so please bare with me. 1st problem concerns entering data as text and it being converted to time. I have found the formula 00\:00 which does an excellant job of converting. However, when I want to subtract, (=a2-a1) for example, it treats the time as a number. Sometimes it works, but if the hours are different, say 23:30- 22:10, it will subtract 2330-2210! Is there a way to make this work?
    2nd problem, related to the first is when I try to avg a column of times, I get a similar effect. I believe the answer to the 1st may help resolve the 2nd, but I'm not sure. any have any thoughts?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Time calculations subtraction and average

    First of all why would you want to enter times as text which means you can't use time arithmetic until you do convert them to time numbers?

    If it's a case of wanting to see two times in the same cell, then capture them first in two cells as proper time numbers and then concatenate them in a third cell as text. Then do your arithmetic with the first two cells.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time Subtraction
    By realniceguy5000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-25-2009, 01:56 PM
  2. subtraction and average
    By gman4609 in forum Excel General
    Replies: 3
    Last Post: 01-22-2008, 03:44 AM
  3. subtraction off time after midnight
    By Steved in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2006, 08:50 PM
  4. [SOLVED] time subtraction problem
    By in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. time subtraction problem
    By in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

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