Difference between 2 times in access.

[shod90]

Dear Gents,
I have a table which have these coloums ( Employee_IN,Employee_Out,Lastness,TotalWorkingHour s)
i need to calculate the following:
1- Employee_Out-Employee_IN = TotalWorkingHours.
Example:
17:00 - 09:00 = 8:00


17:01 - 09:02 = 7:58
16:57 - 08:39 = 8:18

2 - Latness , If the Employee came after 09:30 AM should calculate the lateness .
Example:
Employee In : 9:45 then the lateness will be 09:45 - 09:30 = 0:15 Mins
Employee In : 10:15 then the lateness will be 10:15 - 09:30 = 0:45 Mins


I've tried many times but i honestly failed .

[CJ_London]

have you tried using the datediff function?

https://www.techonthenet.com/access/...e/datediff.php

[ranman256]

Date/time math is done with DATEDIFF, and DATEADD.

[ssanfu]

Just an FYI,

09:45 - 09:30 = 0:15 Mins

Doing this subtraction: 09:45 - 09:30 results in 15 mins (not 0:15 mins)

0:15 is 15 minutes after midnight.

Adding two times results in a new time.
Subtracting two times results in minutes. If you add a zero and the colon ":" in the front of the result, it becomes a time, NOT minutes.

If you subtract 8:31AM from 4PM you get 7Hrs and 29 min, not 7:29 mins
4PM is 16:00, so

16:00 (4pm)
-8:31 (8:31 am)
--------
7 hrs and 29 mins


I have seen many people struggle with this.....