Results 1 to 2 of 2

Thread: Convert HH:MM to Seconds Using Excel 2000

  1. #1

    Convert HH:MM to Seconds Using Excel 2000



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

    I have a cell that shows a calculated time in HH:MM format. The cell is formatted as Time. I would like to convert the contents of the field to seconds. I've tried the Convert function, but it gives me an error.

    I've tried =((Hour(I4) * 3600) + (Minute(I4) * 60)) but the result is always 00:00.

    Can someone tell me what I am doing wrong?

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,479
    Articles
    0
    Excel Version
    365
    Quote Originally Posted by Honduras2811 View Post
    Can someone tell me what I am doing wrong?
    The format of the time-cell hides its value which is in days; multiply by 86400, the number of seconds in a day and remember that the format of the cell should not be any date/time format. Use for eaxample: General

    Another way is to change the format of the cell containing the time to a custom format:
    [ss]
    but it will retain the excel date/time values but show seconds.
    Last edited by p45cal; 2014-06-19 at 12:19 PM.

Posting Permissions

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