+ Reply to Thread
Results 1 to 2 of 2

changing a cell from a time format to a total sum format

  1. #1
    Forum Contributor
    Join Date
    06-28-2009
    Location
    newcastle, uk
    MS-Off Ver
    Excel 2010
    Posts
    187

    changing a cell from a time format to a total sum format

    hi

    not sure how to word it but here goes. i have attached a file that shows when data is collected in the workbook it reverts to a time format.

    for example a 2:2 prediction converts to 02:02 on my workbook.

    Is there a way to program a VBA or a formula to change the 02:02 back to the original 2:2 on the website, or even better, add the numbers so the total value would be 4?

    Thanks in advance

    Gemma
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: changing a cell from a time format to a total sum format

    Use the FormatNumber ... to change the cell's format either to General or to text
    http://www.excelfunctions.net/vba-fo...-function.html
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. Replies: 1
    Last Post: 05-30-2017, 04:45 PM
  2. Changing Cell format based on another cells format.
    By MrStevie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2017, 03:02 PM
  3. Changing Time Format
    By jordan1214 in forum Excel General
    Replies: 2
    Last Post: 11-16-2015, 11:26 AM
  4. [SOLVED] Changing time format
    By Netaji in forum Excel General
    Replies: 3
    Last Post: 11-17-2014, 05:13 PM
  5. Change format of lots of data cell to a time format
    By dazza67 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-24-2013, 03:24 PM
  6. input and display data in cell in h:mm format without changing to time
    By k9mikep in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-25-2010, 04:42 PM
  7. Changing the number to date format and calculating the total incident in a month
    By shahabpk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-11-2009, 10: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