Recent content by bradles

I tried this function Gemma but found it didn't handle times that cross midnight. For example, 22:00 - 06:00 should return 8 hours, however it returned 16 hours. I don't know if there is a way that it can be adapted to work...I'd like to see it though, especially if it saves a few more lines...

Ah-ha. Thanks Gemma. I changed the functions to pass to a variant instead of a string. So far that function is now working. Now I need to translate this to the other functions I have. Fingers crossed. Thanks again. Brad

Hi All, I made a function to calculate the difference in hours between two times. Function TimeDiff(Time1 As String, Time2 As String) As Double 'This function is used to calculate the difference in hours between two times. 'It is capable of handling a finish time that is after midnight...

Hi All, I am setting up a database to help me prepare codes for employees timesheets in order to upload them into our payroll software. The table structure below is just my preliminary thoughts and current ideas and I guess I'm looking for ideas on how to work with my codes. EMPLOYEE TABLE...