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?
Message posted from http://www.yqcomputer.com/