Results 1 to 6 of 6

Convert Text to Time

Threaded View

  1. 07-03-2014, 05:16 PM #1
    ujjwaljha1812
    ujjwaljha1812 is offline
    Registered User
    Join Date
    07-03-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    16

    Convert Text to Time

    Hi friends,

    I have an excel file here. The columns have timings which is in the format '00:00'. When I try to get a total of them, it is taking them as text and not giving the sum.
    I added a zero in front and had to press F2 and then Enter, then only I am getting the summation. Since the data is large, can anyone help me find a solution that I do not have to press F2 and then Enter to each cell.

    I have attached the file here.

    Regards,
    Ujjwal Jha
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Convert text to time
    By namluke in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-05-2014, 08:07 PM
  2. [SOLVED] convert text to time
    By SRSnyder in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2013, 03:22 PM
  3. Time stored as text. How can I convert to data and time?
    By matthewbutterworth in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-07-2013, 10:19 AM
  4. Convert Text to time
    By Grimace in forum Excel General
    Replies: 10
    Last Post: 07-13-2010, 06:37 PM
  5. convert time imported as text to time format for calculations
    By batfish in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-27-2005, 07:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1