Calculating Total Time?

[allen_jr]

Hi, I am trying to create a report that will show employee shift time... I have a query that pulls a "Start Time" and "End Time", and then it calculates total time spent/shift...

What I want to do is create a running total, or just a grand total, of the amount spent by each employee.. I want to ultimately publish it in report format, but not sure how to get that data?

fyi... We produce an annual tradeshow, so I just need to keep track of everyones time over a 5 day period, basically once a year

Any one have any ideas? Thanks so much for any help!

 

[The_Doc_Man]

Search this forum for "Elapsed time" and "total time" using the Search feature at the top of each page.

Be careful when dealing with "time" fields. They carry baggage because Date/Time data is stored as a relative value based on a date/time reference. I.e. it is like a "timeline" variable measuring distance from the reference. The difference between two date/time fields is kept in fractions of a day. So if you compared 8 AM to 2 PM, you would expect to see 6 hours but might actually find 0.25 (days).

Your best bet usually involves not keeping elapsed time as dates but as some other unit, say Minutes, then converting it to hours and fractional hours when working with the total. Or converting to integer hours and remainder as minutes. Various ways exist to skin that cat, so search the forum to get some hints.

 

[allen_jr]

Thanks for the tips.... I am currently using a formula that calculates the "hours spent" in a query for me:

ShiftHours: Format([Start Time]-1-[End Time],"Short Time")

this gives me a number like 04:00 for someone working 11:am-3pm

What I want to do is also create a formula (or something) that will keep a tally of "Spent hours", essentially adding "04:00+03:30+06:00" for example... Each person gains shift hours for each shift they work, and I wonder is there is a way to tally that...

Thanks again, sorry if my explanations seem naive, I am fairly new to Access