Sorry for this quick and rough answer. If FinishTime<StartTime, FinishTime+1-StartTime , FinishTime-StartTime. Hope you can work out what to do from there....
Regards Norman Pearce IM&T Learning Manager The Training Centre Ealing Hospital NHS Trust Developing the foundations for your success -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of volunteerff8 Sent: 16 February 2007 20:53 To: [email protected] Subject: [ms_access] time sheet How do I cal. time when the start time is 23:00 and the end time is 02:00 what is the format to tell how to cal. the time corectly [Non-text portions of this message have been removed]
