Results 1 to 2 of 2

Thread: Not showing time correctly

  1. #1

    Not showing time correctly



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all

    I need help with times in excel 2010
    I exported a list of mp3 durations, but the column shows minutes as hours.
    For example, mp3 duration: 7 minutes and 30 seconds
    in the csv exported files shows as 7:30:00

    Plus, those mp3 with duration over 24 minutes, show also wrong
    For example mp3 duration 27 minutes and 15 seconds
    in the csv exported file shows as 01/01/1900 3:15:00

    I would like them to show like this:
    0:07:30
    and
    0:27:15

    Thanks in advance

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Perhaps?

    =TIME(0,HOUR(A1)+24*DAY(A1),MINUTE(A1))

    copied down

    assuming first time is in A1.


Tags for this Thread

Posting Permissions

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