Hi All,

i'm very new to FileMaker so this maybe a really basic question.

I have a timesheet with StartingDate, TimeStarted,TimeFinished & a calculation field named ElapsedTime to calculate hours worked using

Mod (TimeFinished- TimeStarted+ 86400; 86400)

I then have another Field called ConvertToFraction set as a calculation

Hour(ElapsedTime) & Minute(ElapsedTime) / 60

this converts the time worked into a fraction so 7 hour 30 minutes will show 7.5 - so far so good

The field is set to a number with 2 decimals.

My problem is if a employee enters say 7:00am to 3:00pm the calculation comes out as 80 rather than 8.

How do i fix this.

Thanks in advanced

I'm not sure about your formula for elapsed time. If the time fields are Time fields and on the same date, I use (EndTime-StartTime)/3600 to convert to hours and fraction of hours. The second ConvertToFraction is not needed.

If the time will run across several days, then I would use a custom function. A good source for these is http://briandunning.com.

HTH,

Michele