Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Converting decimal hours to hours minutes and seconds

Tags:

xslt

xslt-1.0

Is there a more elegant solution to the following in xslt 1.0? I understand there are built in functions to xslt 2.0.

I'm taking a number in decimal hours and need to represent it as HH:MM:SS. At the moment I have the following which functions well.

<xsl:variable name="decimal_hours" select="pre_lab_cost div pre_labour_rate"/>
<xsl:variable name="decimal_minutes" select="number(concat('0.',substring-after($decimal_hours, '.')))*60"/>
<xsl:variable name="decimal_seconds" select="number(concat('0.',substring-after($decimal_minutes, '.')))*60"/>
<xsl:value-of select="concat(format-number(floor($decimal_hours), '00'),
                                           ':',
                                           format-number(floor($decimal_minutes), '00'),
                                           ':',
                                           format-number(floor($decimal_seconds), '00')
                                           )"/>
like image 635
Adam Avatar asked Feb 20 '23 12:02

Adam


1 Answers

How about this ...

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>

<xsl:variable name="decimal_hours" select="3.14"/>

<xsl:template match="/">
<xsl:value-of select="concat(
  format-number(floor($decimal_hours              ), '00:'),
  format-number(floor($decimal_hours *  60 mod  60), '00:'),
  format-number(floor($decimal_hours * 360 mod 360), '00'))"/>
</xsl:template>

</xsl:stylesheet>
like image 174
Sean B. Durkin Avatar answered Mar 04 '23 23:03

Sean B. Durkin