How to display duration datetime in Excel

Today i try this event in my pc, i want to check for how long that datetime duration in Excel. I try this with application Microsoft Excel 2007 :

Here the step :

1. Create date start in column and row C4
fill value  = 01-Aug-2011 09:00

2. Create date start in column and row C5
fill value = 20-Aug-2011 10:30

3. Absolute duration in C6 with this formula
=ABS(C5-C4)

4. Then create data detail (about date time duration) in column row C7, with this formula :

=CONCATENATE(TRUNC(TEXT(C6,"[h]")/24)," days, ",HOUR(C6)," hours ",MINUTE(C6)," minutes")

And it work for me, you can try this step.
Have a nice try.

 

Technorati Tags: How to display duration datetime in Excel,duration datetime,duration in excel