Forum Discussion
Creating Daily Timelines in Excel
I am trying to build an autogenerated event timeline. I have been breaking it down for each event and am hoping excel will help shorten that process for me. Essentially the time block is broken down ...
Try these formulas:
I understand that function, but it doesn't apply to this situation. I know the formula I need to do in between, but what I need is if I put in a time in one cell then the next "major event" time slot I would like to auto-generate to 3 hours after that time I put in the original cell. Does that make more sense?
If your time value is in cell A1 use this formula in A2 then drag down:
=A1+1/1440