Calculate hours between two dates (PostgreSQL)

Get Help
1

Hi,

I'm currently exploring Metabase and I'm trying to add a custom column that calculates the hours between Start and End Date. Do you have any advice on how to get started to achieve that?

13
131306×906 72.6 KB

2

Hi @marc
There's a request for having a function in Custom Expressions:
https://github.com/metabase/metabase/issues/16870 - upvote by clicking :+1: on the first post

You would have to do that in SQL, since doing [End Date] - [Start Date] would return an interval/duration type, which cannot be visualized nicely:
https://github.com/metabase/metabase/issues/8875 - upvote by clicking :+1: on the first post

3

Thanks @flamber
Found a way now to solve it.

4

@marc It would help others if you wrote what you did.

5

I just exported the data incl the time difference and did it Google Sheets :slight_smile:
Probably not very helpful for the successors.