[![enter image description here](https://i.stack.imgur.com/Q98bQ.png)](https://i.stack.imgur.com/Q98bQ.png)

In PostgreSQL / pgadmin - How do I cast timestamp (HH:MM:SS) as decimal so I can multiply by hourly\_rate (XX.YY$) and get total charge\_amount?

For the life of me I can't find any reasonably simple solution on Google or this forum.

Can it be that's it's not possible?