# Add a number to a time and continue sequentially

##### Board Regular
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?

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
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)

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))

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

Replies
2
Views
517
Replies
11
Views
320
Replies
1
Views
417
Replies
20
Views
560
Replies
1
Views
197

1,220,965
Messages
6,157,122
Members
451,399
Latest member
alchavar

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back