I am using FMP4 and need to add a time clock capability to our database system. We routinely have people working past midnight into the next day as a continuous work day. I have seen a nicely done example file in FMP7 that returns a continuous block of hours when ever the end time is less than the start time but it appears to depend on a function that is not available in FMP4. Can anyone suggest a way to calculate a field that would return the total hours worked from say 4 pm on one day until 3 am on the next morning without having to have separate records for each day?

Thanks
--
E. Riley Casey
Silver Spring MD
301-608-2180 ph
301-608-0789 fx
301-440-2923 shoe phone
Entertainment Sound Production ( http://www.ESPsound.com )

Reply via email to