Jul 12, 2001 #1 delpino Programmer Joined Dec 29, 2000 Messages 17 Location 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?
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?
Jul 12, 2001 1 #2 Bagger Instructor Joined Jun 18, 2001 Messages 23 Location US 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" Upvote 0 Downvote
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"
Jul 12, 2001 Thread starter #3 delpino Programmer Joined Dec 29, 2000 Messages 17 Location GB there is a syntax error in that expression..must be something wrong Upvote 0 Downvote
Jul 12, 2001 #4 JoeMiller IS-IT--Management Joined Apr 27, 2001 Messages 1,634 Location US 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 Upvote 0 Downvote
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