Time fields store time in seconds so the difference of two time fields computes the elapsed time in seconds.
What kind of values are being recorded in Lunch? multiplying it by 60 does not make sense here. If Lunch = 1 when the person takes a 1 hour lunch, this is the calculation that will return a decimal value in hours:
( Time End-Time Start ) / 3600 - Lunch
Select Number as the return type.
I am recording lunch as minutes, ie :30, :45, :60 etc.
I got the orginal calculation from you back in October, http://forums.filemaker.com/posts/184c0596dd
Ok now I changed the Lunch to Number, ie .5, .75, 1, so my total works out to a normal number ie 8.5.
Is it possibe to make the the lunch field read as time, ie :30, :45, :60, or some varations of that? I tried different options and caculations but could not get it to work.
You can enter lunch in as 30 , 45 ,60 (number) format as currency and change currency symbol to :, this will make your field read :30, :45, :60 and then use the following calculation.
(endtime - starttime) /3600 - (Lunch/60)
Thanks to the both of you. It works great!!