xsl-list
[Top] [All Lists]

Finding total hours between two dates and keeping a running total

2003-11-18 11:03:04
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