Roundup function in an IF statement

[Greg_Stevens]

I am attempting to write an equation but I cannot get Airtable to do what I want. What I am asking is that if “Total Time Worked” is greater than or equal to 7 hours and 45 minutes to round it up to 8 hours. However if “Total Time Worked” is less than 7 hours and 45 minutes do nothing and leave as is. I am trying to calculate this for payout purposes at work and making sure that anyone working at least 7:45 gets a full 8 hours but anyone working 7:44 hours or less simply gets paid for the time they worked.

This is what I wrote: IF({Total Time Worked} >= 7.75, ROUNDUP(7.75,0))

What am I doing wrong here? Any help would be greatly appreciated. Problem here is once this equation is entered what Airtable is now doing is round all hours above 7.5 to 8.

[W_Vann_Hall]

You don’t have an ‘else’ part to that IF() statement. The ‘else’ is optional — except in your case, you need two branches:

IF(
    {Total Time Worked}>=7.75,
    ROUNDUP(7.75,0),
    {Total Time Worked}
    )

Greg_Stevens:

Problem here is once this equation is entered what Airtable is now doing is round all hours above 7.5 to 8.

I bet you have the formula field formatted as an integer. :winking_face:

(I didn’t catch it at first, either – I had to enter it into Airtable to figure out how it failed.)

[Greg_Stevens]

Thank you for your reply! What should I have it set as? I have it set as a decimal for the formatting. Still even with the equation you’ve provided me it is rounding anything above 7:30 to 8.

[W_Vann_Hall]

Double-check how the formula field is formatted. If it’s set to an integer, 7.5 will show as 8. If it’s set as a decimal with a precision of at least 1.0 it will show as 7.5. (A decimal with a precision of 1 is an integer.)

[Greg_Stevens]

I do have my formatting set as Decimal with the precision of 1.0 and still getting everything set to 8. I have one person who worked 7:41 and one person who worked 7:49 and with the equation plugged in it is giving both of these individuals 8 hours.

[W_Vann_Hall]

What type of field is {Total Time Worked}?

[Greg_Stevens]

{Total Time Worked} is a formula field with the equation: DATETIME_DIFF({Shift End},{Start Shift})

[W_Vann_Hall]

Ah… That is giving you the time in seconds. Try

DATETIME_DIFF({Shift End},{Start Shift})/3600

From the help center description of DATETIME_DIFF():

Returns the difference between datetimes in specified units. Default units are seconds. (See list of unit specifiers here.)

[Greg_Stevens]

Okay so I have it set up like this. I have total time worked with lunch as: DATETIME_DIFF({Shift End},{Start Shift}) then I have total time worked as: ({Total Time worked with lunch}-{Lunch Time}). THEN I have this last cell labeled Realized time as: IF({Total Time Worked}>=7.75,ROUNDUP(7.75,0),{Total Time Worked}).

Sorry I misspoke my last reply

[Greg_Stevens]

W_Vann_Hall:

DATETIME_DIFF({Shift End},{Start Shift})/3600

when I added the /3600 to the end of the equation it made my calculated time of 7:41 to 00:00.