Hey all... long time reader of the forum but first time poster. I've been banging my head against the wall for days trying to solve a problem I'm having and I was hoping one of you guys might have an answer.
I have a column with random times of day in ascending order (9:00am, 9:01am, 9:04am, 9:09am, 9:13am, 9:17am, 9:18am, 9:20am, 9:25am). With this list, I'm trying to figure out how to get the range of times in minutes between two adjacent times. For example, if I was looking at 9:00am and 9:01am, I'd type a formula in the cell to the right of 9:01am that would return 9:00am in it's own cell and 9:01am in its own cell. If I was working with 9:04am and 9:09am, I'd type a formula in the cell to the right of 9:09am that would return 9:04am in its own cell, 9:05am in its own cell, 9:06 in its own cell, 9:07 in its own cell, 9:08 in its own cell and 9:09 in its own cell.
Basically, I need to pluck out each minute (in hours and minutes in AM or PM) between two adjacent times of day in a column. These times change multiple times each day and I'm just trying to automate a portion of what I've been doing manually. I'm wondering if there's some sort of magical Excel formula that will work no matter what the range is between the two times.
Thanks in advance!
I have a column with random times of day in ascending order (9:00am, 9:01am, 9:04am, 9:09am, 9:13am, 9:17am, 9:18am, 9:20am, 9:25am). With this list, I'm trying to figure out how to get the range of times in minutes between two adjacent times. For example, if I was looking at 9:00am and 9:01am, I'd type a formula in the cell to the right of 9:01am that would return 9:00am in it's own cell and 9:01am in its own cell. If I was working with 9:04am and 9:09am, I'd type a formula in the cell to the right of 9:09am that would return 9:04am in its own cell, 9:05am in its own cell, 9:06 in its own cell, 9:07 in its own cell, 9:08 in its own cell and 9:09 in its own cell.
Basically, I need to pluck out each minute (in hours and minutes in AM or PM) between two adjacent times of day in a column. These times change multiple times each day and I'm just trying to automate a portion of what I've been doing manually. I'm wondering if there's some sort of magical Excel formula that will work no matter what the range is between the two times.
Thanks in advance!