Kinda weird but I don't know how to copy down dates with hours below them so it would be like that. Excel wants to duplicate the dates when I try
1st Mar 2011
12:00
12:30
13:00
13:30
etc
2nd Mar 2011
same hours
....and so on
Kinda weird but I don't know how to copy down dates with hours below them so it would be like that. Excel wants to duplicate the dates when I try
1st Mar 2011
12:00
12:30
13:00
13:30
etc
2nd Mar 2011
same hours
....and so on
Last edited by przemke; 12-09-2010 at 02:39 AM.
See attached file!
Different attempt
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
Perfect! I was about to say that's damn good Steve but does it have to be that complicated (I wouldn't have time to analyze your long formula)
but then scottylad made the day! +1 ..so simple! :D
Finally it looks as in attachment. Thanks a lot to all for help!
Now there's a little problem with readability, I wanted to share this sheet in google docs but this does not seem to offer zooming. would there be any other online office excel-compatible with that ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks