Format Date/Time as decimal

Wappler General Need Help
1

Is there a way to format date/time, such as 1:30:00 (One hour and 30 minutes) as 1.5 (one and a half hours)?

Thanks,
Chris

2

Hello,
There is no any formatter that does this automatically.
You would need to split the value by : and do some calculations to convert minutes to decimal. Try googling it, to find the right formula which suits your needs.