SpreadEveryone: The Fetchland Excel wire

101 watchers
Neal
Neal
May 2019
3:20pm, 22 May 2019
42 posts
  •  
  • 0
Neal
If that's your only problem, create the pivot table without grouping the dates, then from the menu choose Data -> Group and Outline -> Group...

Monthly intervals is the default.
oumaumau
oumaumau
May 2019
3:23pm, 22 May 2019
1,107 posts
  •  
  • 0
oumaumau
It's a bit weirder than that Neal - the ' appears to come from copy and 'paste special', which only provides a value if 'Text' is selected - then columns formatted as time.... I've done it wrong, haven't I? :)
HappyG(rrr)
HappyG(rrr)
May 2019
3:33pm, 22 May 2019
31,484 posts
  •  
  • 0
HappyG(rrr)
Need to paste as numbers not text, then use the formatting as 00:00:00 oumaumau. Sorry, I didn't come in here to speak Excel, just to ask about cheaper software. :-) G
um
um
May 2019
3:38pm, 22 May 2019
964 posts
  •  
  • 0
um
HappyG - do you have any connection or link to education - see moneysavingexpert.com

Glenn - I suspect you'd qualify - not sure about the cloud storage though - or if that just comes with it.

Or does your employer have a corporate/enterprise license - if so you may qualify for the Microsoft Home Use Program.
HappyG(rrr)
HappyG(rrr)
May 2019
3:42pm, 22 May 2019
31,485 posts
  •  
  • 0
HappyG(rrr)
I'm afraid not. Thanks for suggestions though. I am my own employer (so I get 40% off from Philip Hammond but I'd still rather pay less still!) - I'll prob just get the £64 version. Grrr. Software used to be free! :-) G
oumaumau
oumaumau
May 2019
3:42pm, 22 May 2019
1,108 posts
  •  
  • 0
oumaumau
When I paste special and pick 'number', I get a blank cell....
Neal
Neal
May 2019
3:46pm, 22 May 2019
43 posts
  •  
  • 0
Neal
Ok oum, paste as text so you get the ' at the beginning of your times then fix it by

select the range including the times
CTRL-H for find and replace
In the Find box
.*
In the replace box
&

In other options select "regular expressions"
cross your fingers and click replace all
The times will now be times.
GlennR
GlennR
May 2019
3:46pm, 22 May 2019
42,552 posts
  •  
  • 0
GlennR
Happy G, when Excel first came out it cost way more than the whole Office package now.
HappyG(rrr)
HappyG(rrr)
May 2019
3:50pm, 22 May 2019
31,487 posts
  •  
  • 0
HappyG(rrr)
I worked for a software company and we just swapped our £500 box of software for someone else's. So I never had to pay for software. I agree, it is actually now very reasonably priced.

Maybe I should just persist with Libre Office. I was just disappointed that the first thing I tried to do didn't work the same as Excel! :-) G
oumaumau
oumaumau
May 2019
3:51pm, 22 May 2019
1,109 posts
  •  
  • 0
oumaumau
I like that very much Neal :D.
One day, I'll do this with a database, like I know I should....

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...

Related Threads

  • excel
  • support
  • tech
  • work








Back To Top

Tag A User

To tag a user, start typing their name here:
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 113,880 Fetchies!
Already a Fetchie? Sign in here