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.