I need to calculate total length of time in hours:minutes:seconds.

ColumnA: Arrive date in M/D/YYYY
ColumnB: Depart date in M/D/YYYY
ColumnC: Arrive time in H:M:Seconds
ColulmnD: Depart time in H:M:Seconds

I can't figure out how to get my formulas to look at BOTH date AND TIME
& arrive at a total length of time that honors a period over 24 hours.


I know I can format [H], and I've looked at other formula pieces, but
I'm unable to get all four pieces above to connect.

How do I do that?

Nic.


---
Message posted from http://www.ExcelForum.com/

Hi
use the following formula
=(B1-A1)+(D1-C1)
and format the resulting cell with
[hh]:mm

--
Regards
Frank Kabel
Frankfurt, Germany


> I need to calculate total length of time in hours:minutes:seconds.
>
> ColumnA: Arrive date in M/D/YYYY
> ColumnB: Depart date in M/D/YYYY
> ColumnC: Arrive time in H:M:Seconds
> ColulmnD: Depart time in H:M:Seconds
>
> I can't figure out how to get my formulas to look at BOTH date AND
> TIME & arrive at a total length of time that honors a period over 24
> hours.
>
>
> I know I can format [H], and I've looked at other formula pieces, but
> I'm unable to get all four pieces above to connect.
>
> How do I do that?
>
> Nic.
>
>
> ---
> Message posted from http://www.ExcelForum.com/

Hi Nic!

Try:
=(B1+D1)-(A1+C1)
Format [hh]:mm:ss

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(E-Mail Removed)