Calculating Time elapsed

I am trying to calculate how many business hours have elasped from a certain start dateand time. my business hours are m-f 7:00am-6:00 pm. When someone issues a service request I have 8 business hours to complete, if the call comes in at 4:00pm, (i have 2 hours in that day, plus 6 hours in the next day = 1:00 PM.....That is the date that I want populated so i can look down the list and see what is due

Bhomer,

If you enter your service request time as

11/21/2005 04:00:00 PM

in cell A2, then this formula (in a cell with date time formatting) will work:

=IF(A2+TIMEVALUE("08:00:00")>(INT(A2)+TIMEVALUE("18:00:00")),A2+TIMEVALUE("21:00:00"),A2+TIMEVALUE("08:00:00"))

Make sure that your take out any line feeds that were inserted by the mail readers...

HTH,
Bernie
MS Excel MVP


"bhomer" <[email protected]> wrote in message
news:[email protected]...
>
> I am trying to calculate how many business hours have elasped from a
> certain start dateand time. my business hours are m-f 7:00am-6:00 pm.
> When someone issues a service request I have 8 business hours to
> complete, if the call comes in at 4:00pm, (i have 2 hours in that day,
> plus 6 hours in the next day = 1:00 PM.....That is the date that I want
> populated so i can look down the list and see what is due
>
>
> --
> bhomer
> ------------------------------------------------------------------------
> bhomer's Profile: http://www.excelforum.com/member.php...o&userid=28935
> View this thread: http://www.excelforum.com/showthread...hreadid=486746
>