Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Custom Time Function (MS XL97-2002)

    I have a users that import data from another application in plain minutes (no decimal parts).
    I need to convert those into hours and minutes. Although I can do this with formulae for each entry, I imagine that I need to create a simple (?) function could be run by code that inserted a new column and put the hours and minutes (hh:mm) as a conversion of the number of minutes beside it.
    The bit I can't fathom is how to get XL to realise it has nothing to do with dates and is simply a conversion of minutes to hours and minutes.
    Any suggestions would be appreciated.
    Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Custom Time Function (MS XL97-2002)

    Assuming that the minutes are imported as just numbers, the following formula should work if such a number is A1 (the result shoul be formatted as h:mm :-

    <pre>
    =TIMEVALUE(INT(A1/60)&":"&MOD(A1,60))</pre>


    Hope it helps

    Andrew C

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Australia
    Posts
    245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Custom Time Function (MS XL97-2002)

    Thanks Andrew.

    I wasn't on the right path but that is just what I needed.

    Leigh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •