Help

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.

Using https://eazyform.app/ for time field

Topic Labels: Formulas
2373 7
cancel
Showing results for 
Search instead for 
Did you mean: 
Leslie_Miller
6 - Interface Innovator
6 - Interface Innovator

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.

Screen Shot 2021-11-02 at 4.52.18 PM

7 Replies 7

Hi @Leslie_Miller

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.

Duration 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.

That didn’t quite work
I had
{End Time} - {Start Time}/3600
Screen Shot 2021-11-03 at 7.23.01 AM

Use brackets: ({End Time} - {Start Time})/3600

Good ol’ PEMDAS

I have a new question to get the result I am looking for
Screen Shot 2021-11-07 at 11.14.36 AM

How can I get a Date/Time field to auto populate based 2 duration fields and 1 date field?