Results 1 to 7 of 7

SUM function for time issue

Threaded View

  1. #1
    Registered User
    Join Date
    09-11-2014
    Location
    Riga
    MS-Off Ver
    2007
    Posts
    36

    SUM function for time issue

    Dear users,

    I have encountered an issue and I can't seem to get a fix for it. English isn't my native tongue and maybe I can't seem to find the correct keywords to find a solution, however here it goes.
    Basically I've made a Call Centre statistics excel where we store infomation about answered calls/missed, time when logged on, total time spent talking and so on. I have an application where I export the data I need (in to seperate excel file) and I just copy/paste (as values) that information in to my excel sheet and nearly everything works except one thing.

    So the issue is a simple SUM function for time.

    For example in the month November, I have pasted the total time "idle, working time, work status, post processing" from the other excel which was exported . However the SUM function on the G34,H34,I34,J34,K34 does not work. The time when pasted will be shown as "04:03:50", however if I remove the 0 in front and make it "4:03:50" the sum function will work. Is there a way to force excel to sum the time while value of the cell stays "04:03:50" or make a quick workaround to remove the 0's.

    I have attached the excel file in question.
    Please, tell me if I have to clarify, because it might not be easy to understand what I'm trying to say.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] IF function: Early/On Time/Late Time vs. set window of time
    By hclark579 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2014, 05:37 PM
  2. Time is an Issue Please Help
    By Mailer in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-16-2014, 10:13 AM
  3. [SOLVED] Extracted time from date/time field does not flag on =IF(TIME function.
    By Vlad717 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-09-2013, 03:29 PM
  4. Time issue
    By Zeezar in forum Excel General
    Replies: 5
    Last Post: 09-15-2009, 09:18 AM
  5. Time issue
    By Zeezar in forum Excel General
    Replies: 5
    Last Post: 09-04-2009, 10:56 AM
  6. time issue
    By iwzhidden in forum Excel General
    Replies: 4
    Last Post: 08-28-2008, 09:44 AM
  7. Time issue
    By jcc31 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-05-2007, 05:15 PM
  8. Time issue
    By segger in forum Excel General
    Replies: 3
    Last Post: 02-28-2007, 12:55 PM

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