Thread: Time difference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RobertLees
 
Posts: n/a
Default Time difference


Hi

This might be simple, but please help.

I have a number of events, and want a time associated with each. The
last event has a final time. The previous events have a time gap. I
want those events to have a time which is the previous time minues the
time gap. I think I need something like '=a20-d19', and copied to
previous cells as '=a19-d18' and so on. What do you think ?

Thanks
Robert


--
RobertLees
------------------------------------------------------------------------
RobertLees's Profile: http://www.excelforum.com/member.php...o&userid=26580
View this thread: http://www.excelforum.com/showthread...hreadid=498124