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.
Using https://eazyform.app/ for time field
+8
+25Duration 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.
+29Duration 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.
Duration fields store their time in seconds, not minutes. They display as minutes but when used in formula fields they are seconds.
+25Duration fields store their time in seconds, not minutes. They display as minutes but when used in formula fields they are seconds.
Yes, went a little to fast there.
+8Duration 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.
That didn’t quite work
I had
{End Time} - {Start Time}/3600
+25That didn’t quite work
I had
{End Time} - {Start Time}/3600
Use brackets: ({End Time} - {Start Time})/3600
+8Use brackets: ({End Time} - {Start Time})/3600
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?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.