Date = The date the record is entered
Asleep = The time (hhmm pm) the user fell asleep the previous night
Awake = The time (hhmm am) the user woke up today
HoursSleep = The number of hours the user slept

I've tried a number of calculations. The one that makes the most sense
to me thus far is:

HoursSleep Timestamp ( Date ; Awake ) - Timestamp ( Date - 1 ; Asleep )

But this doesn't produce a sensible result.
Can someone please help?

Thanks,
dp


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/FileMaker/Browse/
Manage your subscription: http://www.ListSearch.com/FileMaker/