All solutions General QuestionsPIVOT TABLE Expert Solution – General Questions on Pivot Table

Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Please assist I have numbers in an excel sheet but the numbers cannot be added up, the numbers appear as a 0 on my pivot table. I have tried the ALT + 0160 trick but its not working. Please assist
Solved by A. A. in 16 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 24/08/2018 - 12:17
HI there, I understand that you need help with adding your numbers but Excel isn't recognizing them, right?
Excelchat Expert 24/08/2018 - 12:18
Are you there?
User 24/08/2018 - 12:18
yes that's correct
Excelchat Expert 24/08/2018 - 12:19
Okay, there's quite a few reasons why this will happen and in order to determine what's causing this, are you able to share your file?
User 24/08/2018 - 12:20
yes I can
Excelchat Expert 24/08/2018 - 12:20
Please upload your file using the clip icon next to this chat.
User 24/08/2018 - 12:21
IO seem to be having difficulty with attaching the file:(
Excelchat Expert 24/08/2018 - 12:22
Is it an .xlsm file?
Excelchat Expert 24/08/2018 - 12:22
Can you save a copy and SAVE AS .xlsx file?
User 24/08/2018 - 12:23
done
[Uploaded an Excel file]
Excelchat Expert 24/08/2018 - 12:23
Thank you. One moment.
Excelchat Expert 24/08/2018 - 12:24
I see a bunch of times in here. Is this what you need help with?
User 24/08/2018 - 12:24
yes I need to add the times up
Excelchat Expert 24/08/2018 - 12:25
I see. So everything, right?
Excelchat Expert 24/08/2018 - 12:25
Is this 24h format or 12h format?
User 24/08/2018 - 12:25
24h format
Excelchat Expert 24/08/2018 - 12:27
Okay, the reason why you can't calculate these is because they aren't really valid times.
Excelchat Expert 24/08/2018 - 12:27
What we can do is to convert them to valid time format by using the timevalue() function.
User 24/08/2018 - 12:27
ok how do I do that?
Excelchat Expert 24/08/2018 - 12:28
First, paste this in B1.
Excelchat Expert 24/08/2018 - 12:28
=TIMEVALUE(A1)
Excelchat Expert 24/08/2018 - 12:28
Then apply it to the end of your list.
Excelchat Expert 24/08/2018 - 12:28
Then select column B, press CTRL+1, select TIME and then select the 24H format.
User 24/08/2018 - 12:30
ohk thanx I see its working now:)
Excelchat Expert 24/08/2018 - 12:30
That's great!
Excelchat Expert 24/08/2018 - 12:30
Glad to have helped!
Excelchat Expert 24/08/2018 - 12:30
Would there be anything else that I can help you with regards to the original question?
User 24/08/2018 - 12:30
no that's all for now...Thanx so much:)
Excelchat Expert 24/08/2018 - 12:31
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert 24/08/2018 - 12:31
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert 24/08/2018 - 12:31
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
User 24/08/2018 - 12:32
will give you the 5-star rating:)
Excelchat Expert 24/08/2018 - 12:32
Thank you I'd appreciate that. It would help me a lot. Please do not forget to click the End Session button so you can rate me.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc