Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

adding text values within

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Adding Text as values within a Pivot Table

Adding Text as values within a Pivot Table

ResolvedVersion 365

Jeevan has attended:
Excel Advanced course

Adding Text as values within a Pivot Table

Is it possible to include a text from source data as a value column within the last column of a pivot table after values?

RE: Adding Text as values within a Pivot Table

Hello Jeevan,

Thank you for your question. I found the following website which shows how to display text in the Values columns of a Pivot Table:

https://sfmagazine.com/post-entry/july-2018-excel-reporting-text-in-a-pivot-table/

I hope this helps.

Kind regards
Marius Barnard
STL

Mon 14 Mar 2022: Automatically marked as resolved.

Excel tip:

Calculate difference between two times

For presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format.

Hours never exceed 24, minutes never exceed 60, and seconds never exceed 60.

=TEXT(B2-A2,"h")
Hours between two times (4)

=TEXT(B2-A2,"h:mm")
Hours and minutes between two times (4:55)

=TEXT(B2-A2,"h:mm:ss")
Hours and seconds between two times (4:55:00)

Where B2 and A2 must hold the end time and start time respectively formatted as a time format

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.68 secs.