Hour Calculation

[Loony22]

I have made a query that displays total amount of hours employee worked (short time format). The huge problem is that I can't display more then 24 hours (again, because of the short time format). Any suggestions how to make a query that will show the total hours worked without the 24 hours limitation?

QryDailyWork :

EmployeeId
LastName
FirstName
DailyWork (short time format, total hours and minutes the Employee have worked during the day)

QryTotalWork:

EmployeeId
LastName
FirstName
TotalWork (short time format, total hours and minutes the Employee have worked during the Month. Sum of all daily work during the month)

 

[lynsey2]

is it just me but how can someone work more than 24hrs in one day???

 

[lynsey2]

yip its just me! you want the total amount for the month!

 

[Loony22]

LOOOOL .

True, i wanted the total amount of work per month

 

[bradcccs]

Why are you storing the "number" of hours as a "time".

I would imagine that a person works 8 hours a day, and not 08:00 (8:00 am) hours a day.

You could represent the number of hours as a decimal eg: 8.5 hours.

If you wish to present the amount of time in a 8:30 style output, I would be processing this, and not storing it as a time.

my two cents.

Brad.

 

[Loony22]

Okie, i should i have told the whole story.

I have this table :

TblWorkTrace :

WorkTraceId
EmployeeId
DateOfWork
StartHour
EndHour

In QrydailyWork :

DailyWork = EndHour - StartHour .
If The format of EndHour and StartHour will be "long" and not "date" how can i subtract between them?
Lets assume that Start Hour = 9:10, EndHour = 10:00.
DailyWork = 9:10 - 10:00 = 0:90 (not 0:50) .

Of course, i cannot replace DailyWork Instead of EndHour, StartHour (EndHour and StartHour are helping the manager know when did the Employee start his work and when did he finish).

 

[lynsey2]

im not very good but i would create another feild and call it total hrs for the day and just use that! then you can have start and stop but solve your problem with total hrs for the day all added up for the end of the month! maybys yes maybys no im sure youll get a better sugestion from someone who actualy knows what they are doing!!

 

[DJN]

You might like to have a look at the Microsoft Knowledge base.


http://support.microsoft.com/default.aspx?scid=kb;en-us;q88657

Hope this is of some help.


David

 

[Loony22]

Thank you very much. This is all i needed .