You would need two dates, start and end, in addition to start time
and end time
Elapsed =
(((EndDate - StartDate) * 86400) - StartTime) + EndTime
that's elapsed time in seconds. to get decimal hours to the tenth,
wrap it in:
Round(Elapsed / 3600,1)
I think that will do it.
Geoff
On Feb 16, 2007, at 11:48 AM, E. Riley Casey wrote:
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 )
