If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating Time Spans
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Calculating Time Spans
If A2 is the date-in, B2 is the time-in and c2 is the date-out and D2 is the
time-out: =(c2+d2) - (a2+b2) Ps. I'd put the date and time into the same cell. You can format it nicely to show both the date and time. I think it makes the arithmetic easier. 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. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|