SSDN - convert seconds to hh:mm:ss

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Gary Haubert

Subject: convert seconds to hh:mm:ss
Author: Gary Haubert
Date: 19 Dec 2007 04:01 PM

I have a cell within a table that has total seconds. Has anyone converted seconds to HH:MM:SS? I would appreciate if anyone can give me a hand with this.

Thank you,
Gary

James Durning

Subject: convert seconds to hh:mm:ss
Author: James Durning
Date: 19 Dec 2007 04:07 PM

hh = seconds / 3600
mm = (seconds / 60) % 60
ss = seconds % 60

Gary Haubert

Subject: convert seconds to hh:mm:ss
Author: Gary Haubert
Date: 20 Dec 2007 07:53 AM

Thank you for the reply. I have the calculation, i was hoping to get a handle on the XSL syntax.

Tony Lavinio

Subject: convert seconds to hh:mm:ss
Author: Tony Lavinio
Date: 20 Dec 2007 03:08 PM

<xsl:variable name="seconds" select="3723"/>
<xsl:variable name="hhmmss">
<xsl:variable name="hh" select="floor($seconds div 3600)"/>
<xsl:variable name="mm" select="floor($seconds div 60) mod 60"/>
<xsl:variable name="ss" select="$seconds mod 60"/>
<xsl:if test="$hh < 10">
<xsl:text>0</xsl:text>
</xsl:if>
<xsl:value-of select="$hh"/>
<xsl:text>:</xsl:text>
<xsl:if test="$mm < 10">
<xsl:text>0</xsl:text>
</xsl:if>
<xsl:value-of select="$mm"/>
<xsl:text>:</xsl:text>
<xsl:if test="$ss < 10">
<xsl:text>0</xsl:text>
</xsl:if>
<xsl:value-of select="$ss"/>
</xsl:variable>
<xsl:value-of select="$hhmmss"/>

Gary Haubert

Subject: convert seconds to hh:mm:ss
Author: Gary Haubert
Date: 20 Dec 2007 03:37 PM

Thank you for your help.

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.