Results 1 to 5 of 5

Converting a whole number into an amount of time

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2009
    Location
    Austin, TX
    MS-Off Ver
    Excel 2011 mac
    Posts
    3

    Converting a whole number into an amount of time

    Can someone pls help? How can the following calculation be formulated?
    field A1 & B1 are variable user input. The goal is to subtract B1 from A1, take the result and divide it by 176 (a fixed number) and display the result as minutes:sec.
    For example
    A1 B1
    14,000 (minus) 2,200 (= 11,800 /176 =) 67
    I want to result (67) to display in field C1 as 01:07 (min:sec)

    I tried (A1-B1)/176 and formatted C1 to be min:sec but the result displays as 5:27 I have no idea what that number represents. Help please?
    Thanks a lot in advance.
    Last edited by jimgatl; 09-07-2009 at 03:43 AM.

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