Toggl and spreadsheets

I'm sure there's a way I could automate this, but I keep track of projects by copy/pasting the number of hours spent on projects from Toggl into a spreadsheet. The trouble is that this then needs formatting into something that the spreadsheet (in this case, Proton Sheets) can deal with.

I always forget how to do this, so this is for reference:

Assuming E3 contains your Toggl raw time:

=INDEX(SPLIT(E3,":"),1)

+ INDEX(SPLIT(E3,":"),2)/60

+ INDEX(SPLIT(E3,":"),3)/3600

This converts, for example, 30:45:00 into 30.75 hours which I can then actually do something with. I swear we wouldn't need half of what generative AI promises if people (I) could use spreadsheets better...