I have a spreadsheet that tracks system outages. I am trying to automatically track the duration of time in minutes that has elapsed between the start time and end time. The spreadsheet is set up using four columns: 1. Start Date 2. Start Time 3. End Date 4. End Time
There are no problems if the outage occurs within the same date. However if the dates vary, such as a start date/time of 6/1 at 7pm and an end time of 6/2 at 3am I end up with bad data. I am attaching a mock copy of what my sheet looks like.
I am sure that this is probably something simple that I am overthinking.
Thanks in advance to any and all that contribute.
Bookmarks