So I'm trying to deal with data exports to use in PowerBi. I have a due by date for a ticket in 7 days. But in the export it says: 02:31.0
I'm not sure what that's in. I figured out that 0.00 is overdue (would be nice for this to be done in date tho so I can calculate it myself) But some tickets are 0.0 despite not being due yet. There's 59:59.0 as well but not sure what that means.
Just need some assistance with this export and due by dates.