Working out Total Hours worked (Running over Mid Night) 1

[scoombs]

Hello.

I have a form and I enter in:

TimeIn
TimeOut

It is a night shift the database is for.

I need a field that will work out how many hours have been worked. Example Hours:

22:00 - 05:00

Look forward to someone's Solution.

Thanks,

Steve Coombs

 

[PHV]

IIf(TimeIn<=TimeOut, TimeOut-TimeIn, 24-TimeOut+TimeIn)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[willir]

Good use of IIF.

I posted a less eloquent solution here...
Time Calculation

The only real difference is that the solution uses the DateDiff function.

Richard

 

[PHV]

Just discover a bug:
IIf(TimeIn<=TimeOut, TimeOut-TimeIn, 1-TimeOut+TimeIn)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244