98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Example for pivot table question.
Example for pivot table question.
Resolved · High Priority · Version 2007
Sat 21 Mar 2009, 14:08Delegate Adrian said...
Adrian has attended:
Excel Advanced course
Example for pivot table question.
Hi,
Re: my previous question about showing schedule data in pivot tables, here's what I'm doing with the result:
Data:
ORIGIN DESTINATION EQUIPMENT TYPE DAYS OF OPERATION DEPARTURE TIME ARRIVAL TIME
ADD AUH 'ABF 5 15:40:00 20:10:00
Formula:
=A2&";"&B2&";"&C2&";"&D2&";"&E2&";"&F2
Result:
ADD;AUH;'ABF;5;0.652777777777778;0.840277777777778
Anybody any suggestions as to how to avoid the corruption of 24 Hr time format?
Mon 23 Mar 2009, 10:29Trainer Stephen said...
RE: Example for pivot table question.
Hi Adrian
Thanks for this update. I didn't see it before replying to your previous post
I could still do with seeing the workbook so that I can see the source data and table settings and properties
Regards
Stephen
Mon 23 Mar 2009, 19:57Delegate Adrian said...
RE: Example for pivot table question.
Hi Stephen,
I am trying to recreate a method used by Bill Jelen in his "Power Excel 2007" DVD. I'll send you the workbook separately as there doesn't seem to be an option to attach.
Thanks for the interest,
Adrian.
Fri 8 May 2009, 11:02Trainer Rich said...
RE: Example for pivot table question.
Hi Adrian,
Did you manage to get the file to Stephen? If not, please forward to forum@stl-training.co.uk and I will pass it to him. Please quote the URL of this post for easy reference.
Thank you.
Rich
Fri 29 May 2009, 09:38Trainer Rich said...
RE: Example for pivot table question.
Hi,
This question has now been left unattended for a while.
We like to keep down the large number of active forum posts we receive.
As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).
We look forward to hearing from you.
Thank you.
Regards, Rich
Sat 30 May 2009, 11:40Delegate Adrian said...
RE: Example for pivot table question.
Hi Rich,
Just sent the Bill Jelen file (to the forum email address) that explains the multiple consolidation range technique. Let me know if you want the schedule data file as well (it's exactly the same info. as I posted in the first thread).
Cheers,
Adrian.
Mon 1 Jun 2009, 09:16Trainer Rich said...
RE: Example for pivot table question.
Hi Adrian,
I have received the file, thanks.
I will pass it on to Stephen who can have a look at it and get back to you via this post.
Regards, Rich
Mon 1 Jun 2009, 10:13Trainer Rich said...
RE: Example for pivot table question.
Hi Adrian,
How about this?
=A2&";"&B2&";"&C2&";"&D2&";"&HOUR(E2)&":"&MINUTE(E2)&":"&SECOND(E2)&";"&HOUR(E2)&":"&MINUTE(E2)&":"&SECOND(E2)
Basically getting the Hour, Minute and Second information and appending semi-colons between each one.
Does that work for you?
Regards, Rich
Mon 3 Aug 2009, 10:26Trainer Rich said...
RE: Example for pivot table question.
Hi Stephen,
Did you manage to look at the file?
Regards, Rich
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Remove unused toolbar buttonsAre there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following: |
