time - How to Calculate Duration in Hours Using Google Data Studio

Question

I'm trying to get the duration in hours using data stored in Google sheets using the following fields and display the data in Google Data Studio.

I was able to get the results I wanted in Google sheets using =(H2-I2)*1440. However, I want the managed the calulation using Google Data Studio. I tired using CAST(EndTime AS NUMBER ) - CAST(StartTime AS NUMBER ) in Google Data Studio but that didn't seem to work.

Answer 1

Waitting for answers