Calculating Time Spans
A1 = Date in
B1 = Time in
C1 = Date out
D1 = Time out
Try the formula;
=C1+D1-(A1+B1)
and format the formula cell as below... FormatCEllsCustomType as below
[h]:mm
--
Jacob (MVP - Excel)
"LabITGeek" wrote:
I'm trying to figure out how to calculate the duration between the
"date/time" in to the "date/time" out. I have four cells DATE IN, TIME IN,
DATE OUT, TIME OUT. I have to somehow merge DATE IN/TIME IN and DATE
OUT/TIME OUT and then subtract the difference. But I can't seem to figure
how to merge the two cells and to obtain a realistic duration.
|