Convert date difference to second, minutes and hours
Posted on 2008-06-14
I need to calculate the time between two dates into hours, minutes and seconds between the two times. Say, a task starts at 6/13/2008 3:30:51 PM and end at 6/13/2008 7:10:28 PM, I need to the total time in hours, minutes and second. I started with the DateDiff using seconds as the unit, but simply dividing by 60 would get total minutes, but the remainder for seconds is in tenths, rather than the seconds I want. How do I transalate into a resul of say 3 hours, 25 minutes and 15 seconds?