Hi Guys,
we are currently trying to import timesheets from toggl to airtable. toggl naturally saves time in the format: 00:20:24, but this is in airtable currently not calculatable. The conversion of the fields doesn’t work correctly like you can see...
Many thx again @W_Vann_Hall , this worked perfectly for me and now everything is rounded correctly. One last question again:
is there a way to round it to the next bigger 0.25 unit? like when it`s 0.1 round to 0.25?
Happy eastern by the way and best ...
Great, many thx for your big help @W_Vann_Hall ! Your hint worked like a charm. Just one more question:
How could the converted number be rounded to the next nearest 0.25 hour? meaning if it’s 0.3 it should be 0.25, if it’s 0.4 it should be 0.5?
Man...
