Displaying Time values in a Pivot Table

[LouisT]

Hi Everyone, I'm trying to create a Pivot Table with employee data that also has time values in it. But i can't figure out how to get the time to show the result in the raw data. I guess the best was to describe it is similar to using an Index formula and returning the answer. Is there a way to do that with a pivot table?

Here's an example of the raw data and the desired outcome attached.

Thanks in advance for your help.
LouisT