View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LabITGeek LabITGeek is offline
external usenet poster
 
Posts: 1
Default 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.