How do you find average time (of three times)?

[deckthehalls]

Hi all,

I am trying to calculate the average time between three columns. Example below. 

	Day 1	Day 2	Day 3
Indiana	05:00	05:30	06:00
Florida	14:40	14:05	15:00

Not sure if there is an easy way to solve. Thanks in advance!

[DavidP]

Hi @deckthehalls 

This is how I would do it

[csmith11]

Pretty Similar Solution as David, just joined back together at the end.

Also I used a parse tool to convert the initial time to a Time data Type. This avoids the awkwardness of needing to append 0s to the initial time.