Elapsed Time by Hour of the Day

**eternalimit** · 10-13-2011, 01:59 PM

I am trying to calculate the number of minutes that elapsed in an hour.

My example is that I have a start and end time.

Start End
9:00 11:15

I want to calculate the number of minutes that occured in the 9:00 hour, the number of minutes that occured in the 10:00 hour and the number of minutes that occured in the 11:00 hour.

It would look like this

9:00 10:00 11:00
60 60 15

I am stuck and a formula to calculate this and any help would be appreciated.

Best regards,
Eternalimit

**tlafferty** · 10-13-2011, 02:04 PM

Do you want the formula to return 3 results in one cell, ie 60, 60, 15. Or one result in three cells 60 60 15, or do you want the formula to calculate the total and place it in one cell, ie 135?

**eternalimit** · 10-13-2011, 02:06 PM

I would like the formula to return one value in 3 cells. ie under 9:00 60 under 10:00 60 under 11:00 15.

**tlafferty** · 10-13-2011, 02:21 PM

See attached workbook using the hour and minute formulas.

**eternalimit** · 10-13-2011, 02:28 PM

Thanks for the help

how can your example formula apply to a list of 8000 with random combinations of times?

example
7:00 7:45
7:30 10:00
8:00 11:00
8:00 8:50
8:30 12:00
12:00 14:00...