Results 1 to 5 of 5

Need Formula to convert Minutes into hh:mm:ss

Threaded View

  1. #1
    Registered User
    Join Date
    11-22-2008
    Location
    Ottawa, ON, Canada
    Posts
    16

    Need Formula to convert Minutes into hh:mm:ss

    Ok .. here is the problem . . .
    I have a spot on my spreadsheet where I am given an ammount of time in minutes.
    I need to convert it to hours:minutes:seconds (ie: hh:mm:ss)
    Can anyone help??

    Example:
    6214.11 must be converted to 103:43:12
    In other words:
    6214.11 minutes becomes 103hours, 43mins, 12 seconds

    Can be done either one of 2 ways ...
    Dont care which as long as it works.

    Either:
    A3=PRODUCT(A1,A2)
    B1=(formula here converting answer from A3 to hh:mm:ss)
    OR
    use the current
    A3=PRODUCT(A1,A2)
    and somehow change the number format to show it the way i need it to.
    (none of the preset number formats works unless you have a custom one i can use)
    Last edited by Powrpak; 11-24-2008 at 06:27 PM.

Thread Information

Users Browsing this Thread

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

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