SUM of CONCATENATE

[JaMeZ88007]

I'm trying to create a turn around time statistic table.
The formula i have gotten so far is as below:

=CONCATENATE(TRUNC(ROUND(((G10-E10)*1440),0)/1440,0)," Days ",TRUNC(MOD(ROUND((G10-E10)*1440,0),1440)/60)," Hours ",ROUND(MOD(ROUND((G10-E10)*1440,0),60),0),"

However, the data format must be mm/dd/yyyy hh:mm. Is there a way to create a statistic using the same formula but with the mm/dd/yyyy and hh:mm separated?

When i tried to separate the data to date and time, there is a problem.

For example, cell D15 is 3/1/2012, E15 is 16:36 while cell F15 is 3/2/2012, G15 is 15:15. The total TAT should be 22 hours and 39 minutes. But the formula i used gave me 1 day 22 hours and 39 minutes instead.

Is there an alternate way? Or is it that the data MUST be mm/dd/yyyy hh:mm?

[TMS]

Why don't you just use normal arithmetic (adds take-aways) in both cells and then format them as you require?

[kvsrinivasamurthy]

Try this
=F15+G15-D15-E15

[JaMeZ88007]

Thanks! The last formula works.