Results 1 to 4 of 4
  1. #1
    Junior Member
    Join Date
    Aug 2006
    Posts
    85

    Default excel - count time

    I want to record lengths of time spent on phone calls in excel & have a total in hours & minutes, but it keeps insisting on using date format.

    I enter the time in the format 10:30 for 10 minutes & 30 seconds. If I custom format the values as [mm]ss for minutes & seconds, it changes them into a time of day. It turns my example into 10:30am

  2. #2
    Senior Member pctek's Avatar
    Join Date
    Feb 2005
    Location
    In the Wild West
    Posts
    24,212

    Default Re: excel - count time

    Doesn't for me.
    I checked what it used and its on Custom, hh:mm:ss. Try formatting it like that.

  3. #3
    pcsourcepoint
    Join Date
    May 2006
    Location
    Otara, Auckland
    Posts
    3,063

    Default Re: excel - count time

    Could get a bit tricky if difference fall across two different days, so a tweak is required which is shown here
    Computer Tech Links (My Tutorials & Reviews)| Free MP3 Software Reviews (My Reviews)|I Student NZ (My Student Resoucre Tips)

  4. #4
    Junior Member
    Join Date
    Aug 2006
    Posts
    85

    Default Re: excel - count time

    Quote Originally Posted by pctek View Post
    Doesn't for me.
    I checked what it used and its on Custom, hh:mm:ss. Try formatting it like that.
    still sees it as date and time, but it works as long as the total doesn't get to 24 hours or more.

Similar Threads

  1. Excel - Conditional Search/Sum or Count
    By GrahamB in forum PressF1
    Replies: 3
    Last Post: 09-07-2003, 05:35 PM
  2. time formulas in Excel
    By in forum PressF1
    Replies: 2
    Last Post: 24-01-2002, 05:35 PM
  3. Time in Excel
    By in forum PressF1
    Replies: 0
    Last Post: 08-11-2000, 12:10 PM
  4. Replies: 0
    Last Post: 30-06-2000, 12:16 AM
  5. Replies: 0
    Last Post: 13-04-1999, 10:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •