Formula for converting time in hours ex. 12.30-16.00 = 3.5 hours
0
520
0
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!
