Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

difference between times 1

Status
Not open for further replies.

delpino

Programmer
Dec 29, 2000
17
0
0
GB
how can i calculate the hours between 2 times like:

9:30 and 16:00

i want the hours between these times.

PS: anybody knows if there are any freeware timesheets access programs out there?
 
I have use this statement many times.

You can use the following logic to calculate the difference between two times which works even across midnight.

Format([StartTime] -1 -[EndTime], "Short Time")
 
there is a syntax error in that expression..must be something wrong
 
I wrote a timesheet proggie once that's REALLY simple, if you'd like it send me an email and I'll forward it to you.

Joe Miller
joe.miller@flotech.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top