Simple Script: update field using another field.

[Leslie_Miller]

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.

[Databaser]

Hi @Leslie_Miller

Leslie_Miller:

I am having trouble then figuring out what formula to use to calculate total hours for employee scheduling.

Duration fields (start time & end time) store their value in seconds. In your “total hours” field, divide by 3600 to calculate the hours.

Leslie_Miller:

Additionally I would like to be able to view in a Calendar view.

You will need at least 1 date field for this.

[kuovonne]

Databaser:

Duration fields (start time & end time) store their value in minutes.

Duration fields store their time in seconds, not minutes. They display as minutes but when used in formula fields they are seconds.

[Databaser]

Yes, went a little to fast there.

[Leslie_Miller]

That didn’t quite work
I had
{End Time} - {Start Time}/3600

[Databaser]

Leslie_Miller:

{End Time} - {Start Time}/3600

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

[Kamille_Parks]

Good ol’ PEMDAS

[Leslie_Miller]

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?