Time after Time

Hi,

I have found lots of interesting stuff about time here, but one thing
is eluding me.


I need to be able to find the elapsed time between when a call was
taken and the time that the case was resolved.
Easy enough you say and it is.


Then I need to compare the elapsed time with a constant value, ie. 2
Hours, 4 hours, 48 hours and 120 hours.


I have tried doing this in an excel spreadsheet but no luck.


so here it is in psudo code;


WorkTime = Start Time - Finish Time

If Worktime > 2 and SLA = 1 then
objworksheet.value = "Over Sla"
End if


And so on and so on.

OldDog

ThatsIT
Sat Jun 16 10:14:13 CDT 2007


"OldDog" <michael.r.felkins@wellsfargo.com> wrote in message
news:1181961698.972398.294980@g4g2000hsf.googlegroups.com...
> Hi,
>
> I have found lots of interesting stuff about time here, but one thing
> is eluding me.
>
>
> I need to be able to find the elapsed time between when a call was
> taken and the time that the case was resolved.
> Easy enough you say and it is.
>
>
> Then I need to compare the elapsed time with a constant value, ie. 2
> Hours, 4 hours, 48 hours and 120 hours.
>
>
> I have tried doing this in an excel spreadsheet but no luck.
>
>
> so here it is in psudo code;
>
>
> WorkTime = Start Time - Finish Time


this would give you a negative number.

you would need

WorkTime = Finish Time - Start Time


>
> If Worktime > 2 and SLA = 1 then
> objworksheet.value = "Over Sla"
> End if
>
>
> And so on and so on.
>
> OldDog
>

OldDog
Sat Jun 16 10:23:21 CDT 2007

On Jun 16, 10:14 am, "ThatsIT.net.au" <me@thatsit> wrote:
> "OldDog" <michael.r.felk...@wellsfargo.com> wrote in message
>
> news:1181961698.972398.294980@g4g2000hsf.googlegroups.com...
>
>
>
>
>
> > Hi,
>
> > I have found lots of interesting stuff about time here, but one thing
> > is eluding me.
>
> > I need to be able to find the elapsed time between when a call was
> > taken and the time that the case was resolved.
> > Easy enough you say and it is.
>
> > Then I need to compare the elapsed time with a constant value, ie. 2
> > Hours, 4 hours, 48 hours and 120 hours.
>
> > I have tried doing this in an excel spreadsheet but no luck.
>
> > so here it is in psudo code;
>
> > WorkTime = Start Time - Finish Time
>
> this would give you a negative number.
>
> you would need
>
> WorkTime = Finish Time - Start Time
>
>
>
>
>
> > If Worktime > 2 and SLA = 1 then
> > objworksheet.value = "Over Sla"
> > End if
>
> > And so on and so on.
>
> > OldDog- Hide quoted text -
>
> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

OK, noted