Timesheet calculations - next start time in 6min increments

Hello

I have searched forums today to no avail. I am very inexperienced with Excel and feel like this might be quite a simple question!

This is what I want to do:

A1 - initial start time [8:00 AM]
B1 - end time [8:05 AM]
C1 - rounded up to number of six minute units indicated as a decimal [0.1] formula =ROUNDUP(HOUR(B1-A1)+DOLLARDE(MINUTE(B1-A1)/60,10),1)
D1 - indicated as minutes [.06] formula =C1*0.6

I have the above working ok so far. What I want to do is then have a formula so that A2 is however many 'units' (i.e. six minute increments) later than A1. So, I need the formulas to automate A2, A3 and so on, in the following example:

Excel query.jpg

Please help!!

Thank you.

Put this in A2:

=A1+TIME(0,6,0)

then copy down as far as you need to.

Hope this helps.

Pete

Try putting the following formula in cell A2 and drag-copying it down as needed:

=CEILING(B1,"0:06")

Thanks Pete - I changed the calculations slightly so that Column D is indicated as a whole number, and used the formula =A1+TIME(0,D1,0) instead, which worked! Thank you :-)

Thanks Root_ - I used a variations of Pete's formula above which has worked