April 15, 2008 at 10:31 am
Hi all,
Have a problem with a system i am currently developing. It is a request based system for physical files. When a user requests a file it has a requestedOn datetime and an sla attached to it.(90 minutes, 4 hours or 24 hours). I want to be able to show the time remaining for the request taking into consideration the working hours are monday to friday 7am till 9.30pm and saturday 10am till 6pm. So outside these hours the time remaining should not keep ticking...
Can anyone tell me where to go about solving this? I pretty certain something like this has to have come up before if just in a different variety. I have being looking at a business hours calculator http://www.codeproject.com/KB/datetime/CalculatingBusinessHours.aspx but this doesnt deal with the sla side of things.
Cheers
N.
April 15, 2008 at 11:00 am
I may be misreading this, but it seems to me that if an account has 90 minutes on its SLA, and you calculate the business minutes, you should be able to subtract business minutes from 90 and get how many there are left. So, what am I missing?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 16, 2008 at 4:55 am
Cheers. Was adding the business hours to request time instead of taking it away from the sla. hence my problems with the result.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply