Total Number in Time

[jgandino]

Background: People sign in on a form, time in, time out. A form calculates the number about of time on position.

Problem: I am having trouble having a query or whatnot calculate the total time on position, overall, in hours and minutes. I know if it goes over 24 hours it will just reset to 0000, but I need it to show like 125.25. One hundred and twenty five hours and 25 minutes, 25/100ths minutes. Thanks again.

 

[WayneRyan]

jg,

Just use a long date/time stamp to record the Start/Stop times.

Then you can easily use the DateDiff function to get elapsed time.

Wayne

 

[jgandino]

That is what I started to do to get the time difference after midnight, and it worked great. Will what you suggested return a value of something greater than 24 hours? And if so, how should I disply the return value, number/text/[date/time]? Thank you for your help.

 

[WayneRyan]

jg,

The real point is that using DateDiff function will let you calculate the
interval for any span of time. It is just one function call to return the
interval for a single unit (years, months, days, hours, minutes, seconds).

To get a "compound" return will require a little bit more work, but not much.

What do you need?

Wayne

 

[jgandino]

Compound

I will need it to compound the total time an individual is signed on like the following:

Situation: A person comes in,signs on with his/her initials, and if he/she is a trainer, controller, supervisor.

Problem: I need it to reflect the total time a person, sorted by initials, is signed on to each position, and how they are signed on..

I hope this helps.