xsl-list
[Top] [All Lists]

RE: Finding total hours between two dates and keeping a running total

2003-11-18 13:19:12
XSLT 2.0 / XPath 2.0 has a wide range of functions for date arithmetic
and formatting. 

If you need an XSLT 1.0 solution you might look at the date/time
libraries in EXSLT (www.exslt.org)

Michael Kay

-----Original Message-----
From: owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com 
[mailto:owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com] On Behalf Of 
kakridge(_at_)bellsouth(_dot_)net
Sent: 18 November 2003 18:03
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] Finding total hours between two dates and 
keeping a running total


I currently have XML like this portion:

<ArrayOfReservation>
      <Reservation>
              <StartDate>2003-11-13T09:00:00.0000000-05:00</StartDate>
              <EndDate>2003-11-13T17:00:00.0000000-05:00</EndDate>
      </Reservation>
      <Reservation>
              ...
              ...
      </Reservation>
              ...
              ...
              ...
</ArrayOfReservation>

How can I:

1. Display 9:00 AM and 5:00 PM instead of 09:00 and 17:00

2. Get the total number of hours between the two times( problems arise
for   me when I have multi day events). 

3. Display the total number of hours for all 
reservations(this is most important, and I am completely 
stumped on this one.  I imagine it has something to do with a 
variable, but I am a novice and keep getting variable scope errors).


Thank you in advance for your help.


-Kenny Akridge


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list