Skip to main content

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

  • November 24, 2023
  • 0 replies
  • 4 views

Forum|alt.badge.img+5

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!