Results 1 to 2 of 2

convert hh:mm:ss into total seconds

This is a discussion on convert hh:mm:ss into total seconds within the Microsoft Access forums, part of the Question Forums category; I created a simple query to calculate the "incident duration" from an incident start (hh:mm:ss) and end time (hh:mm:ss) into ...

  1. #1
    Board Regular
    Join Date
    Feb 2006
    Location
    New York
    Posts
    166

    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
    or
    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
    Location
    Denver, Colorado USA
    Posts
    4,201

    Default

    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.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm
    (My other life: http://damonostrander.com )

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
  •  


DMCA.com