View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Josh W Josh W is offline
external usenet poster
 
Posts: 55
Default Help with time formula

I am trying to create a time formula in increments of 15 minutes then 5
minutes then again 15 minutes then 5 minutes etc as follows::
cell A1 08:00
cell A2 08:15
cell A3 08:20
cell A4 08:35
cell A5 08:40
cell A6 08:55
Cell A7 09:10
How do I do this? Thanks, Excel 2003.