create stacked column chart to show running time

[fruitloop44]

I have data on 5 runners for 1 week; start time and end time in a race. I want to graph how long it took each runner to finish the race when I subtract the cells for start and end time, I get a result as 3:00 AM instead of 3 hours. I think this is why I'm having an issue creating a stacked column chart

how can I subtract 2 timestamps and get it to spit out just the hours instead of another time stamp?

I want the date on x axis and time to complete the race on y axis

thank you

here is a sample of the data https://imgur.com/xRyDynl

i want a stacked column chart that has dates on the x axis. so 1/1 will have 1 bar that has 30 mins for racer 1, 35mins for 2, and 40 mins for 3

[MrShorty]

how can I subtract 2 timestamps and get it to spit out just the hours instead of another time stamp?

Not knowing what all you've tried, it can be difficult to say. Standard answer would be =C2-B2 and formatted with an appropriate number format (I would expect elapsed hours "[h]:mm", but it sounds like you are using time of day "h:mm AM"). Assuming the value in B2 is 0.375 days (or 9:00 AM when formatted as time of day) and C2 is 0.39583333333 (or 9:30 AM when formatted as time of day), then C2-B2 should yield 0.0208333333 (or 0:30 when formatted as elapsed hours [h]:mm).

Creating the chart should be straightforward. It's not clear to me exactly what you want the final chart to look like, but with appropriate values in a standard chart arrangement, you should be able to get a stacked column chart with little difficulty. Remember when creating a stacked chart that the "second" value in a stack adds on to the first, so you will often need to calculate a difference. If you want the three runners times to stack on top of each other so that the first runner's column ends at 30 minutes, the second's ends at 35 minutes, and the third's ends at 40 minutes, the values in the spreadsheet will need to be 30 minutes, 5 minutes, and 5 minutes. As you build the table of values for the chart, be mindful of exactly what values you need in this table.

Does that help at all?

[fruitloop44]

subtracting the cells worked, thank you!