Time calculation in excel

[jpsabourin]

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

 

[Roger Govier]

Hi

With start time in A1 and end time in A2 either
=(A2-A1)*24-15
format cell as General or Number and you will see decimal hours as the
result
or
=A2-A1-15/24
format cell as hh:mm and you will see hours and minutes as the result.