I have a file which contains the open and close activity for a store over multiple days. What I am trying to do is to provide an average opening and closing time for the store. What I need to do is convert the time column to a numerical field and then summarize on that field. For example, in Excel converting 7:30 AM to numeric results in 0.31. That is exactly what I am trying to do in Alteryx. Any help?
