+ Reply to Thread
Results 1 to 7 of 7

How to Convert date or time into seconds

  1. 06-08-2015, 11:40 PM #1
    Arpita_Excel
    Arpita_Excel is offline
    Registered User
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007,2013
    Posts
    63

    How to Convert date or time into seconds

    Hello all,

    I want to convert the number into the time format hh:mm:ss.

    For Example:- 21033 should be display in time format hh:mm:ss.

    thanks
    Reply With QuoteRegister To Reply
  2. 06-08-2015, 11:44 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: How to Convert date or time into seconds

    is 21033 days, hours, mins or secs?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 06-08-2015, 11:48 PM #3
    Arpita_Excel
    Arpita_Excel is offline
    Registered User
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007,2013
    Posts
    63

    Re: How to Convert date or time into seconds

    Yes, it should be look like as 2:10:33.
    Reply With QuoteRegister To Reply
  4. 06-08-2015, 11:52 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: How to Convert date or time into seconds

    Try this...
    =TIME(LEFT(A1,IF(LEN(A1)=5,1,2)),MID(A1,IF(LEN(A1)=5,2,3),2),RIGHT(A1,2))
    Reply With QuoteRegister To Reply
  5. 06-09-2015, 12:41 PM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: How to Convert date or time into seconds

    Thanks for the feedback
    Reply With QuoteRegister To Reply
  6. 06-11-2015, 02:11 AM #6
    Arpita_Excel
    Arpita_Excel is offline
    Registered User
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007,2013
    Posts
    63

    Re: How to Convert date or time into seconds

    it works
    Reply With QuoteRegister To Reply
  7. 06-11-2015, 02:13 AM #7
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: How to Convert date or time into seconds

    Happy to help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to convert date/time to seconds
    By christopher.marin@gmail.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-18-2006, 08:30 PM
  2. How to convert time into seconds.
    By mangesh in forum Excel General
    Replies: 3
    Last Post: 06-26-2006, 07:25 PM
  3. Need help: convert seconds to date and time
    By misty1 in forum Excel General
    Replies: 2
    Last Post: 11-26-2005, 12:12 AM
  4. Convert seconds to time
    By Tod in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-10-2005, 08:06 PM
  5. How do i convert a number of seconds to a date/time?
    By Margo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2005, 09:06 PM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1