Results 1 to 3 of 3

Thread: Convert 24 hours to 48 hours in excel

  1. 11-14-2011, 04:00 PM #1
    dhiraj.ch185
    dhiraj.ch185 is offline
    Junior Member
    Join Date
    Sep 2011
    Posts
    14
    Rep Power
    0

    Question Convert 24 hours to 48 hours in excel

    Hi,

    How can i convert 24 hours timing to 48 hours. For example 01:00:05 should be displayed as 25:00:05 in excel.


    Thanks in advance.
    Reply With Quote Reply With Quote
  2. 11-14-2011, 06:09 PM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi Dhiraj,

    Welcome to ExcelFox !!

    Custom format the cell as

    [h]:mm:ss

    HTH
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  3. 11-15-2011, 09:02 AM #3
    dhiraj.ch185
    dhiraj.ch185 is offline
    Junior Member
    Join Date
    Sep 2011
    Posts
    14
    Rep Power
    0
    Worked for me.. Thank you very much.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Calculate the Hours
    By leopaulc in forum Excel Help
    Replies: 2
    Last Post: 02-27-2013, 02:51 PM
  2. Hours Calculation between two times
    By excel_learner in forum Excel Help
    Replies: 3
    Last Post: 11-21-2012, 05:04 PM
  3. Using VLOOKUP to convert US State Abbreviations ...
    By gamouning in forum Excel Help
    Replies: 5
    Last Post: 10-02-2012, 09:37 PM
  4. convert/export excel 2007 chart to powerpoint editable chart
    By pushkar_jethi in forum Excel Help
    Replies: 1
    Last Post: 05-20-2012, 12:23 PM
  5. Convert Series into Range.
    By ayazgreat in forum Excel Help
    Replies: 13
    Last Post: 03-26-2012, 08:49 PM

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
  •  

Forum Rules