Calculate hours

[phpatrick]

Hi,

Situation : someone is getting in on 07.45 AM and leave at 09.15 AM. So you can say he has been there for 1 hour 30.
Because there are at least two checkins and checkouts on a day, I like to count al the minutes between a checkin and a checkout and divide bij 60 to get the hours the person was present.

With wich formula or function do you get the minutes between an beginning time (eg 7.45) and stop time (eg 09.15) 120 minutes.

Person is setting the machine time on clicking (event) on a button.

 

[TheAceMan1]

How are ya phpatrick . . .

The following also [blue]allows for midnight crossover[/blue]:

[blue] DateDiff("n", Me!Time1, Me!Time2) + (Me!Time2 < Me!Time1) * (-1440)[/blue]

See Ya! . . . . . .