How do you calculate a time between a time?

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

Guest

I have been on this project for weeks now, I was hoping someone could help me?
Same as previous one, but I still can not get this to work.

I have two fields: Date/Time Started and Date/Time Finished. If I create a
third field called Amount of Time Spent, Is there a function I can include in
it that will calculate the amount of time elapsed between Date/Time Started
and Date/Time Finished?
Can some one email me the cells in access 97 format. I'm really at my wits
end, please help. If you want just Email me at (e-mail address removed) or call me
at 1-800-537-0509 option 0 nad have the operator call me. Thanks in advance,
Peg
 
Try
datediff("d",date1,date2) this will give the difference in days.
datediff("h", date1,date2) will give the difference in hours

Ed Warren
 
I have been on this project for weeks now, I was hoping someone could help me?
Same as previous one, but I still can not get this to work.

I have two fields: Date/Time Started and Date/Time Finished. If I create a
third field called Amount of Time Spent, Is there a function I can include in
it that will calculate the amount of time elapsed between Date/Time Started
and Date/Time Finished?
Click to expand...

The DateDiff function will do this. It is literally a date/time
difference - it does not account for nights, weekends, lunches or
holidays, so I'm not sure it will meet your needs. See the online help
for DateDiff in the VBA editor for details, but to get the number of
miNutes ("m" is Months) use

DateDiff("n", [Date/Time Started], [Date/Time Ended])

Put this expression in a vacant field cell in a Query; you cannot and
should not store this difference in any table cell.
Can some one email me the cells in access 97 format. I'm really at my wits
end, please help. If you want just Email me at (e-mail address removed) or call me
at 1-800-537-0509 option 0 nad have the operator call me. Thanks in advance,
Peg
Click to expand...

Done... but please be aware that this request is considered impolite.
The newsgroups are free and for everyone, staffed by unpaid volunteers
like me. Private email support is for paying customers; if it's worth
my time to volunteer to post answers, it should be worth yours to come
back to the newsgroup for them.

John W. Vinson[MVP]
 
Back
Top