[xsl] Finding total hours between two dates and keeping a running total

Subject: [xsl] Finding total hours between two dates and keeping a running total
From: kakridge@xxxxxxxxxxxxx
Date: Tue, 18 Nov 2003 13:03:04 -0500
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


Current Thread