Excel 2007 : Need Excel to Calculate Every 3 Hours in Day/Time Format

**tiffanyannweber** · 06-23-2011, 10:08 AM

Hi Everyone:

Please help! I got this to work yesterday by autofilling, but I can't remember how.

Basically I'm creating a posting chart for SM that needs to be in a certain forma for bulk uploads. One of these posts need to post every 3 hours, every day.

All in one cell, the format must read dd/mm/yyyy hh:mm. I need this pattern to continue.

Yesterday I could use the autofill somehow and just drag the series down - it autofilled the times and changed the dates. HELP!

25/06/2011 00:15
25/06/2011 03:15
25/06/2011 06:15
25/06/2011 09:15
25/06/2011 12:15
25/06/2011 15:15
25/06/2011 18:15
25/06/2011 21:15
26/06/2011 00:15
26/06/2011 03:15
26/06/2011 06:15
26/06/2011 09:15
26/06/2011 12:15
26/06/2011 15:15
26/06/2011 18:15
26/06/2011 21:15
27/06/2011 00:15
27/06/2011 03:15
27/06/2011 06:15
27/06/2011 09:15
27/06/2011 12:15
27/06/2011 15:15
27/06/2011 18:15
27/06/2011 21:15

**MarvinP** · 06-23-2011, 10:29 AM

Hi tiffany and welcome to the forum,

See http://www.jegsworks.com/Lessons/num...s/autofill.htm about half way down in the Copy Numbers: section.

You will need to fill in 2 cells, the second one 3 hours more than the first and select them both and pull the lower right corner of the 2 selected cells down.

**tiffanyannweber** · 06-23-2011, 10:53 AM

When I do that it calculates like this:

30/06/2011 00:15
30/06/2011 03:15
30/06/2011 00:16
30/06/2011 00:16
30/06/2011 03:16
30/06/2011 00:16
30/06/2011 03:16
30/06/2011 00:16
30/06/2011 00:16

I need it to increase every 3 hours, and then change the dates. It did it yesterday - for the life of me I just can't figure out how!