LiveHelpNow Help Desk

Support Center

BASIC

ADVANCED

Exact Match:

  • Home
  • Categories
  • Sign in
  • Home
  • Categories
  • |
  • Sign in
  1. Home
  2. Categories
  3. Time Duration in Excel

Time Duration in Excel

  • Date updated 2015-12-03
  • Author LiveHelpNow
  • Comments 0
  • Rating
  • Categories
  • General Questions
  • Services and Features
  • Training Resources
  • Troubleshooting
  • Tags
  • Analytics
  • reports

Why does time duration in reports show as time in Excel?

By default, Excel displays the format hh:mm:ss as time am/pm when clicked whether it is real time or time duration. This is just they way Excel views the data within the cell, but you may still add time duration if needed.

 

As refered to an article from Microsoft here are the steps to take to accomplish this to show total time duration.

Source: https://support.office.com/en-us/article/Add-or-subtract-units-of-time-9a6558a1-a86b-41d4-b244-1000fc7d31e9

 

Suppose that you want to know how many hours and minutes it will take to complete two tasks. You estimate that the first task will require 12 hours and 45 minutes and the second task will require 15 hours and 30 minutes.

  1. In cell A1, type 12:45, and then type 15:30 in A2.

  2. In cell A3, type =A1+A2.

By default, Excel interprets the time values you entered in the two cells as elapsed time from midnight. In this case, adding 12:45 to 15:30 results in 28:15, which is equal to one full day plus 4:15.

However, if the cells in which you entered the time values were originally set to the General format, Excel returns 4:15 as the result (28:15 minus 24 hours). To make Excel display the value that you expect (in this case, 28:15), do the following:

  1. On the Home tab, in the Cells group, click Format, and then click Format Cells.

  2. In the Format Cells dialog box, click the Number tab.

  3. Under Category, click Custom.

  4. In the Type box, type [h]:mm.

    TIP   You can also show the results in minutes and seconds by setting the format to [m]:ss, or minutes only by typing [m].

  5. Click OK.

    Excel displays 28:15 if you used the format [h]:mm).

 

 

Rate this article


Your email is now subscribed to alerts for this article

Your email is not subscribed to alerts for this article

Subscribe to alerts for this article below

Unsubscribe to alerts for this article below


Leave a comment?

Related articles

  • What is LiveHelpNow? Why should i choose LiveHelpNow for my business?
    • 29759
    • 30
    • 0
  • What is an ASP (Application Service Provider)?
    • 22983
    • 90
    • 0
  • Why LiveHelpNow Help Desk Software is Different
    • 30428
    • 34
    • 0
  • I have multiple web sites I would like to support. Is this possible with LiveHelpNow ?
    • 20645
    • 57
    • 0
  • What are the Software Requirements for running the LiveHelpNow Alerter?
    • 28884
    • 64
    • 0
  • How many web agents does my site require?
    • 21652
    • 59
    • 0
  • Can my agents handle multiple chats at a time?
    • 26659
    • 66
    • 0
  • Are there any limitations in the Trial account?
    • 25511
    • 59
    • 0
  • Can I keep my settings after my free trial expires?
    • 24082
    • 91
    • 0
  •  How fast can chat be set up on my site?
    • 30944
    • 59
    • 0

Popular Knowledge Base Articles

  • Customize with different languages
    • 22206
    • 27
    • 0
  • LiveHelpNow Section 508 Compliance & Accessibility for Visually Impaired Users
    • 17630
    • 61
    • 0
  • Unsecured content warnings
    • 16504
    • 57
    • 0
  • HelpOut Tab - changing Chat, Ticket and Callback button images
    • 24299
    • 27
    • 0

Knowledge Base Authors

  • Michael Conde
    Michael Conde
    Total articles: 11
  • LiveHelpNow
    LiveHelpNow
    Total articles: 254

Company Sites

Home

Blog

Categories

  • General Questions
  • Getting Started
  • Customization
  • Advanced Customization
  • Troubleshooting
  • All Categories

Connect With Us

  • LiveHelpNow, LLC
  • Customer Support Software
  • 515 S West End Blvd
    Suite 202
    Quakertown, PA 18951

  • 8775483001
  • help@livehelpnow.com
  • https://www.livehelpnow.net
    Powered by LiveHelpNow customer support suite