Results 1 to 5 of 5

How to calculate sum of time difference

Threaded View

  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    Leeds, UK
    MS-Off Ver
    MS Office 2016
    Posts
    79

    Arrow How to calculate sum of time difference

    Hi
    I have a start and end time column and in the next column (C) I’m calculating time difference. Now I need the total of time diff. But the problem is if the total in more than 24hr excel automatically changing the time to next day,
    For example in column C I’ve following time difference

    09:00:00
    06:30:00
    11:00:00
    I want the total which is 26:30:00. But excel showing it as 02:30:00 which is 2:30 AM of next day time. How do I get the total value??
    Last edited by Abhijit2011; 11-23-2011 at 08:27 AM.

Thread Information

Users Browsing this Thread

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

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