Results 1 to 2 of 2

Thread: convert hh:mm:ss into total seconds

  1. #1
    Board Regular
    Join Date
    Feb 2006
    New York

    Default convert hh:mm:ss into total seconds

    I created a simple query to calculate the "incident duration" from an incident start (hh:mm:ss) and end time (hh:mm:ss) into minutes.

    In the query the expression I used was this...
    "Incident Duration: [Incident End Time]-[Incident Start Time]*24*60"

    The problem is I'm not getting the results i wanted. I'm getting the results it in dd/dd/dd/ hh:mm:ss format.

    Example of results Im looking for.

    If start time= 9:44:00 and end time= 23:00:00, result should be 796.00
    If start time= 11:38:27 and end time= 11:41:30, result should be 3.05

    Any ideas of what I can do?

  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Denver, Colorado USA


    Hi Avery,

    First of all, you will need some parentheses to make the expression you have calculate correctly. It should be:

    "Incident Duration: ([Incident End Time]-[Incident Start Time])*24*60"

    Of course, I'm assuming the start and end times in this formula are cell references.

    Secondly, you must format the cell to display the result not as a time or date, but as a simple number (e.g., "General").
    Keep Excelling.


    VBAexpert Excel Consulting
    LinkedIn Profile
    AllExperts Profile

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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