How can I calculate elapsed time for time sheet records? I have a field for start time and end time both setup as time fields.

quote:

---

Originally posted by digital gardener:

How can I calculate elapsed time for time sheet records? I have a field for start time and end time both setup as time fields.

---

Setup the following calculation defined as a time result:

Time Elapsed = End Time - Start Time

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.inthescene.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=

Hi there

I have a similar set up to digital gardener, but I have a field called "meal break" where I enter either 30 minutes or 1 hour which deducts from the "total hours" field to reflect actual working hours.

I'm trying to devise a calculation for the "total hours" field to show: End time - Start time - Meal break.

I've tried a few variations to no avail.

Any ideas?

Many thanks

Tim

I have a field called "meal break" where I enter either 30 minutes or 1 hour

What type of field is "meal break" and what exactly do you enter into it?

What type of field is "meal break" and what exactly do you enter into it?

Hello comment

Well at the moment the field is set up as Number and it is used to enter the duration of meal/lunch breaks which are unpaid and are usually 30 or 60 minutes. So 30 or 60 minutes will be deducted from the total hours for any given day.

Example: Tim started work at 9:00am and finished at 5:30pm but had 30 minutes for lunch. So the total hours should be 8.

Cheers

Tim

Filemaker counts time in seconds, so you cannot subtract minutes from time without converting them to seconds first. Try either =

End time - Start time - Meal break * 60

with the result type set to Time, or =

( End time - Start time - Meal break * 60 ) / 3600

with the result type set to Number (of hours).