hello everyone! i have this table that clocks in and clocks out people at work, but i would like that it would subtract 30 minutes(lunchbreak)
so the person would clock-in then later clock-out and at clockout would subtract -30mins
this is what i cur...
Justin_Barrett:
((VALUE(LEFT({Hours Worked}, FIND(" hrs “, {Hours Worked}) -1), 2) * 60) + VALUE(MID({Hours Worked}, FIND(” hrs ", {Hours Worked}) + 5, 2))) * 60
it works now! thank you so much for the help!
W_Vann_Hall:
configuration box of a formula field; Airtable will strip out the indentations and formatting correctly.(In addition, the block of text has been tagged as ‘code’, so single and double quotes maintain the proper encoding.)
IF(
{P...
Thank you so much for your reply.
Well i dont know much about formulas, we have only 1 shift.
Is it possible to add something like if hours equals or bigger than 4hours then -30mins?
Thanks again for ur help
