I have a table with two columns, the initial date and the final date.
I know how calculate days hours and minutes between them with datediff.
But i need to calculate the total days, hours and minutes of all rows in the end.
inidate enddate result
01/01/2014 01:30 02/01/2014 03:00 1d 1h 30m
03/01/2014 01:30 05/01/2014 03:00 2d 1h 30m
Total: 2d 3h 00m
Anyone know a easy way to do this?
Thx in advanced,