ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Time difference (https://www.excelbanter.com/excel-discussion-misc-queries/63142-time-difference.html)

RobertLees

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



All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com