Add a number to a time and continue sequentially

[schmadly]

How do I add a number to a time?

Scenario: I have one column that lists the length of a given course (Number format). The second column shows the time that it starts. What I need is for the next row to take the length of a given course and add it to the time of the previous row.

Example: If I type in 1.5 (length) and 8:00 AM (start time), the next row underneath the 8:00 AM should automatically populate with 9:30 AM.

What I've tried: =F6+TIME(E6,0,0)
This takes the start time (F6) and uses the Time function to pull the hour and add it - however, I can only get this to work for whole numbers. If I type in 1.5 (meaning 1 1/2 hours) it doesn't add properly. I tried =F6+TIME(E6,(E6*60),0), but that just adds another hour. Any ideas?

 

[Jonmo1]

The problem is that Excel Reads time as a fraction of 1.

1 = 24 hours
.5 = 12 hours (or half of 1 day)

so to excel, 1.5 = 24 hours, + 12 hours

Try

=F6+(E6/24)

 

[schmadly]

Thanks,
I couldn't get the equation to go as you gave it. I tried incorporating it into the following equation. Not sure what to do.
=IF(B7="","",D7+TIME(B7,(C8/24),0))

 

[Jonmo1]

=IF(B7="","",D7+(C8/24))