Can we show time differense in business hours


I have sone device downtime datas like
DeviceName, DownTime, UpTime
DeviceX, 12.06.2020 09:51, 12.06.2020 13:18

I need to report as business hours (between 10:00-22:00)

DeviceX - 3:18


@serkanbaybuga You would have to make the calculation in SQL. Metabase currently doesn’t handle time/date via Custom Expressions: - upvote by clicking :+1: on the first post