to find out if given work is done in given time interval

3.00/5 (1 vote)

See more:

I have a lastupdated field and have working hour(start and end) and a list of holidays
and a max time allowed to complete a work , now i need to find out if the work exceeded the max time or not.

e.g

lastupdated = '1-6-2014'

working hrs

start: 9:00
end:18:00

max time allowed : 9

and a holiday list

and now if i click a button it will tell me if time on work exceeded or not.

Posted 8-Jan-14 19:34pm

agha_ali22

Updated 9-Jan-14 20:46pm

TorstenH.

Add a Solution

Comments

Karthik_Mahalingam 9-Jan-14 1:36am

need more info...

agha_ali22 9-Jan-14 1:46am

see the updated question

Karthik_Mahalingam 9-Jan-14 1:54am

ok ,
what is the holiday list ?
and what is lastupdated ??

agha_ali22 9-Jan-14 2:02am

list of dates that contain holiday we have to exclude that time and last updated is the date when user will start the work

Karthik_Mahalingam 9-Jan-14 2:04am

lastupdated date to today ??

agha_ali22 9-Jan-14 2:14am

no it eill be that date when user will start the work it may be 2 days earlier or yesterday, there is also work completed flag which i am check when querying db that do not include that result

Karthik_Mahalingam 9-Jan-14 2:20am

still not clear,
please rephrase your question, by posting all your requirements.
you are adding new terms in every reply.

agha_ali22 9-Jan-14 4:12am

ignore the work completed flag just wanted to tell you that i am already filtering the records. to summarize it , all i wanted to get is if time on work exceeded then the max time allocated in bussiness hours and excluding holidays.

Karthik_Mahalingam 9-Jan-14 4:17am

what is from date and end date ?

agha_ali22 9-Jan-14 6:20am

working hours

Karthik_Mahalingam 9-Jan-14 7:34am

i mean .
from date -- ??
end date -- ?
from your question..

TorstenH. 10-Jan-14 2:47am

I added the hoework tag. Please post code. we do not provide solutions.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Rick York	90
OriginalGriff	60
Pete O'Hanlon	40
Test Mail May2023	20
Dave Kreskowiak	10

Pete O'Hanlon	1,860
OriginalGriff	1,395
Graeme_Grant	895
Richard Deeming	808
Dave Kreskowiak	694

to find out if given work is done in given time interval

Add your solution here

Preview 0

to find out if given work is done in given time interval

Add your solution here

Preview 0

Existing Members

...or Join us