Formula for converting time in hours ex. 12.30-16.00 = 3.5 hours

Topic Labels: Data Formulas Workflow Design
192 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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

WhatsApp Image 2023-11-24 at 13.56.28.jpeg

Thank you very much for your help!

0 Replies 0