Can we show time differense in business hours

Get Help
1

Hello,

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

Regards

2

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