Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating time difference over midnight! sygazelle Excel Discussion (Misc queries) 4 September 29th 05 04:59 PM
How can I use a time difference in a subsequent formula in Excel? numberman37 Excel Worksheet Functions 10 July 26th 05 07:42 PM
Time Difference Jennifer Excel Worksheet Functions 2 December 22nd 04 04:00 PM
What is the formula for getting time difference e.g. ("4 hrs 15 m. Sandeep Manjrekar Charts and Charting in Excel 3 December 4th 04 05:18 AM
Time / Formula to look at time difference carl Excel Worksheet Functions 5 November 8th 04 06:59 PM


All times are GMT +1. The time now is 04:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"