View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jpsabourin@quickbusiness.com is offline
external usenet poster
 
Posts: 15
Default Time calculation in excel

I have a package which was picked at 04/07/2007 15:30 and we have
until 04/08/2007 12:00 to deliver the package.

The problem is I want the hours for delivery time to be calculated but
to exclude the hours from 17:00 until 08:00.

If I caculate with excel and it is delivery by 04/08/2007 09:30 it
will show hh:mm as 18:00 hours, I want it to only show 3 hours of time
that has elapsed.

Any help would be greatly appreciated.

JP