The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Nov 02, 2021 04:54 PM
I’m using Eazyform app to get time slots separate from the date/time field. I am having trouble then figuring out what formula to use to calculate total hours for employee scheduling.
Additionally I would like to be able to view in a Calendar view.
Nov 03, 2021 02:38 AM
Duration fields (start time & end time) store their value in seconds. In your “total hours” field, divide by 3600 to calculate the hours.
You will need at least 1 date field for this.
Nov 03, 2021 04:56 AM
Duration fields store their time in seconds, not minutes. They display as minutes but when used in formula fields they are seconds.
Nov 03, 2021 06:03 AM
Yes, went a little to fast there.
Nov 03, 2021 07:23 AM
That didn’t quite work
I had
{End Time} - {Start Time}/3600
Nov 04, 2021 01:19 PM
Use brackets: ({End Time} - {Start Time})/3600
Nov 04, 2021 01:44 PM
Good ol’ PEMDAS
Nov 07, 2021 10:19 AM
I have a new question to get the result I am looking for
How can I get a Date/Time field to auto populate based 2 duration fields and 1 date field?