Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
How can I use a time difference in a subsequent formula in Excel? | Excel Worksheet Functions | |||
Time Difference | Excel Worksheet Functions | |||
What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Time / Formula to look at time difference | Excel Worksheet Functions |