Calculate difference in date and time

  • Thread starter Thread starter D Johnson
  • Start date Start date
D

D Johnson

Hello. I am running Access97.

I need to calculate the number of days and hours, or just total hours
between two date fields and two time fields. Example: How many days and
hours (or total hours) from 07/01/2003 08:30:25 AM to 07/04/2003 02:30:12
PM? [Beginningdate] [Endingdate] currently formatted as mm/dd/yyyy and
[Beginningtime][Endingtime] currently formatted as hh:mm:ss AM/PM.

Is there a way to convert and combine the date and time to create numbers
that can be manipulated mathematically? I cannot change the field formats
of the underlying table, but can do what I want in the query and report.

Thank you for your time and knowledge.
 
Thank you very much.

--
D. Johnson

John Spencer (MVP) said:
DateDiff("n",[BeginningDate]+[BeginningTime],[EndingDate]+[EndingTime]) \ 60

That should give you the whole hours between the two datetimes. If you want
Hours and Fractions of hours reverse the slash (from \ to /). The above assumes that:
There is always a value in each date and each time
The dates don't have any times associated with them other than midnight
The times don't have any dates associated with them other than the zero date.


D said:
Hello. I am running Access97.

I need to calculate the number of days and hours, or just total hours
between two date fields and two time fields. Example: How many days and
hours (or total hours) from 07/01/2003 08:30:25 AM to 07/04/2003 02:30:12
PM? [Beginningdate] [Endingdate] currently formatted as mm/dd/yyyy and
[Beginningtime][Endingtime] currently formatted as hh:mm:ss AM/PM.

Is there a way to convert and combine the date and time to create numbers
that can be manipulated mathematically? I cannot change the field formats
of the underlying table, but can do what I want in the query and report.

Thank you for your time and knowledge.
Click to expand...
Click to expand...
 
Back
Top