Calculating Time

[plantfinder]

Can I use something like DateDiff [TimeIn], [TimeOut]) to
calculate elapsed time?

I'm not interested in the date. I have the fields set to medioum time,
i.e 11:30 AM

I don't know vba and really don't have time to learn if it's
avoidable. Im doing this for my business and am not a programmer.

Thanks

Mike

 

[Golom]

Yes ... but the correct format for DateDiff is

DateDiff ("n", [TimeIn], [TimeOut])  [red]<-- Minutes[/red]

OR

DateDiff ("h", [TimeIn], [TimeOut])  [red]<-- Hours[/red]

 

[SkipVought]

"I'm not interested in the date."

IF your times span more than one day, you MUST specify the date/time, or account for the days difference.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]