+ Reply to Thread
Results 1 to 3 of 3

Time formatting, looking to add up durations in a column. NOT looking for time of day.

  1. #1
    Registered User
    Join Date
    12-07-2008
    Location
    Montana
    Posts
    4

    Time formatting, looking to add up durations in a column. NOT looking for time of day.

    Hello,

    I am trying to create a list in Excel with a number of tasks. I would like to assign a time duration to each task, then add up the durations to come up with a total for the column. I am NOT looking to input time of day, simply duration in hours & minutes (I do not care about seconds). Is this possible in Excel?

    Thank you in advance!

  2. #2
    Registered User
    Join Date
    12-07-2008
    Location
    Montana
    Posts
    4

    Re: Time formatting, looking to add up durations in a column. NOT looking for time of day.

    Solved?

    Even though the times that I entered as hours & minutes (hh:mm), the formula display in the cells shows time relative to 12:00:00 am.

    However, when I do a sum of the column in question the total number of hours & minutes is correct.

    Thank for your patience!

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,646

    Re: Time formatting, looking to add up durations in a column. NOT looking for time of day.

    It is really not clear for me.
    But, it may helps you:
    If you have time input in A1 like this:
    A1=8:00 (=8/24)
    B2=A1*24 = 8
    Quang PT

+ 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. [SOLVED] calculating time durations
    By masterintraining in forum Excel General
    Replies: 5
    Last Post: 07-21-2020, 12:14 AM
  2. Using Time Durations
    By ryan.wherry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2018, 01:11 PM
  3. handling of time durations
    By excelstarter2014 in forum Excel General
    Replies: 4
    Last Post: 11-27-2014, 10:55 AM
  4. Excel 2007 : Adding Time Durations
    By FF-EMT Bourque in forum Excel General
    Replies: 1
    Last Post: 04-13-2012, 01:11 PM
  5. time durations within time periods (greater than/less than?)
    By rosieb13 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-08-2007, 10:38 AM
  6. [SOLVED] How do I show multiple time durations in a column bar chart?
    By Basil Bonner in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-01-2006, 03:10 PM
  7. [SOLVED] Time durations in excel and VB
    By Owen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2005, 07:05 AM

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