calculating time/dates differences

I'm looking for a formula that will allow me to calculate the difference
between the time and date of one day and the next. I also need to be able
subtract out the time between 17:00 ahd 08:30 as well as weekend days and
holidays. Example 6 June 16:51 to 7 June 9:51

Here's some formulas and information that might help:
http://www.officearticles.com/excel/...soft_excel.htm
The most important part is the formatting of the cell that contains the
formula.

Also, when you subtract dates/time, the answer is provided in DAYS. So if
you want the number of hours, you have to add /24 to the end of your
formula.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"fvglassman" <[email protected]> wrote in message
news:[email protected]...
> I'm looking for a formula that will allow me to calculate the difference
> between the time and date of one day and the next. I also need to be able
> subtract out the time between 17:00 ahd 08:30 as well as weekend days and
> holidays. Example 6 June 16:51 to 7 June 9:51

"Anne Troy" <[email protected]> wrote in message
news:[email protected]...

> Also, when you subtract dates/time, the answer is provided in DAYS. So if
> you want the number of hours, you have to add /24 to the end of your
> formula.

I think you mean *24 Anne :-)

Uh. Thanks, Bob!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
>
> "Anne Troy" <[email protected]> wrote in message
> news:[email protected]...
>
> > Also, when you subtract dates/time, the answer is provided in DAYS. So
if
> > you want the number of hours, you have to add /24 to the end of your
> > formula.
>
> I think you mean *24 Anne :-)
>
>