+ Reply to Thread
Results 1 to 2 of 2

Excel text time to mm:as help

  1. #1
    Registered User
    Join Date
    04-15-2012
    Location
    rugby, england
    MS-Off Ver
    2003
    Posts
    2

    Excel text time to mm:as help

    Hi guys new on here as you can see.
    I have been browsing to try to resolve this to no avail. So here we go, any help much appreciated.

    Importing info to excel from another system at work, the format it enters the cell in is text as bellow for example.

    5.86

    Note the three spaces before the text starts. This value denotes 5.87 mins (system sees 1 min as 100). To get a value that is equivalent to the rest of the calculation that is needed I need this equate in a cell as 05:52 (52 being 87% of 60 secs). Not fussed if I need to put a few columns in and hide but any ideas on the resolution. Starting to bang my head against a walk with it.
    Chees all
    Aaron

  2. #2
    Registered User
    Join Date
    04-15-2012
    Location
    rugby, england
    MS-Off Ver
    2003
    Posts
    2
    Not solved by the way tis an android app bug....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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