Dates/Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

First, I want to thank you folks in advance for the replies and helpful tips. I have a weekly timesheet form that has time fields which may or may not be blank and they may have times that begin in the evening of one date and ends in the morning of the date after. These time fields are in this format : hh:mm. How can I incorporate all these things in one formulae

Much Thanks
Ron_

P.S. Using Office System 2003
 
First, I want to thank you folks in advance for the replies and helpful tips. I have a weekly timesheet form that has time fields which may or may not be blank and they may have times that begin in the evening of one date and ends in the morning of the date after. These time fields are in this format : hh:mm. How can I incorporate all these things in one formulae?

Much Thanks,
Ron_D

P.S. Using Office System 2003
Click to expand...

Access stores Date/Time fields as floating point numbers, counts of
days and fractions of a day (times) since midnight, December 30, 1899.
The format merely controls how the value is displayed, not what's
stored.

Store the date and time as just one field. The Now() function returns
the current date and time (accurate to a few microseconds, though it
can only be displayed to the second). If you store the date and time
in the same field, you can use DateDiff() to determine shift lengths,
even over midnight.
 
Back
Top