Using for time field

Topic Labels: Formulas
1271 7
Showing results for 
Search instead for 
Did you mean: 
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?