ExcelBanter - Time Increments

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time Increments (https://www.excelbanter.com/excel-worksheet-functions/70775-time-increments.html)

Hi
Theres probably an easy answer to this one but i cant work it out.

I have a starting time on a timesheet of 8.00am (Cell A1) i want to
increasing the time by 5mins in every cell below it. ie. B1 = 8.05am C1 =
8:10am

What do i use??

Cheers

Andrew,

Use the following formula in cell A2 and copy down as far as you
need to go.

=A1+TIME(0,5,0)

Format the cells for time only -- Excel will try to help by
including the date.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Andrew C" wrote in message
...
Hi
Theres probably an easy answer to this one but i cant work it
out.

I have a starting time on a timesheet of 8.00am (Cell A1) i
want to
increasing the time by 5mins in every cell below it. ie. B1 =
8.05am C1 =
8:10am

What do i use??

Cheers