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 )
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?
- calc for wrapping time around midnight? E. Riley Casey
- Re: calc for wrapping time around midnight? Geoff Graham
