Hello, i'm trying to wrap my head around this particular problem.

Main problem

I have an Airtable column that shows the time someone has entered and another column that shows what time he finishes, i would like to find a way to create another column able to convert these times in hours worked

Secondary problem

It would be nice if it also can considerate the night/day difference, for example starting at 11AM and finishing at 2AM

EDIT: They are both Single Text fields

Thank you very much for your help!