Just subtract the lesser from the larger and format as [hh]:mm

--
HTH

Bob Phillips

"zjay" wrote in message
...
How do I make a formula in excel which will allow me to calculate the
duration in hours and minutes of two different dates and times? IE:
1/1/05
01:00 to 1/2/05 01:00 is 24 hours and 0 minutes.