+ Reply to Thread
Results 1 to 2 of 2

Problem in entering large time values in Excel 2003

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2003
    Posts
    93

    Problem in entering large time values in Excel 2003

    Hello experts

    I have this problem in Excel 2003 .
    When I enter time values > 24 hrs it is taking only the part of the time excluding 24 hrs.
    For ex if I want to enter 25 hrs and 40 mins and if i enter 25:40 cell formatted as [h]:mm it is taking 1:40

    but the same thing is working in the computer where there is Excel 2007 version.

    any help ?

    kmahesh

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Problem in entering large time values in Excel 2003

    Use the following string as a Custom Format to format the cell:

    [h]:mm:ss
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. Entering GPS coordinates into Excel 2003
    By Suomalainen in forum Excel General
    Replies: 6
    Last Post: 09-23-2013, 04:13 PM
  2. Problem entering Time Data
    By K m in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-28-2013, 11:00 PM
  3. Replies: 2
    Last Post: 10-24-2008, 05:15 AM
  4. entering negative time values in excel
    By dona in forum Excel General
    Replies: 5
    Last Post: 03-13-2006, 04:25 AM
  5. Replies: 2
    Last Post: 12-14-2005, 04:15 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