Attached Screenshots. Issue 1: View - Slack-Send Tomorrow's ScheduleThis view will send tomorrows(Friday) employee schedule to a Slack channel at 7pm every night. I'd like this view to automatically change to Saturday's Schedule, on Friday Morning. I...
Current Formula: DATETIME_DIFF({End Time},{Start Time},'hours') But if I have a "Day-Off", no date + time are listed, so on these line items they return NAN. If start + end date are blank, return 0 (Zero). Searching the community post, I have not bee...
Can you help with calculating the minutes? Start Time: 7/26/2023 6:15pm End Time: 7/26/2023 7:30pm Formula returns 1 Hour Formula Using: IF({Start Time}= BLANK(), 0,DATETIME_DIFF({End Time}, {Start Time}, 'hours'))
Hi Kuovonne, This formula kind of works. It's rounding up the hours. If I have someone working 8:15am - 3:00pm, it returns 6 hours. Not 5.45. Is it possible to get the exact hours and minutes in the formula?
