Option for field to see total hours open per location, per month?

Yext export shows list of locations with hours in the format: 9am-10pm. Is there an option to see sum of total open operational hours a location is open for the week or month? For example, 9am-10pm, to have a field showing 13hrs. OR if 9am-10pm was their open time 7 days a week, for it to show 91hrs ? I have list of a few thousand locations so the export with 9am-pm within the same cell makes it difficult to calculate across all locations.

1 Like