Number of Hours&Minutes between Dates and time
 

A1= 2/11/2008 13:00:00 (Monday) - Date order entered
B1= 2/12/2008 13:00:00 (Tuesday) - Fixed date to determine age of order

C1 = 24:00:00 Age of order
(This is the formula I need) I need to be able to take out weekends and
holidays.
So for the weekends

A1=2/1/08 15:00:00 (Friday) - Date order entered
B1=2/4/08 15:00:00 (Monday) Fixed date to determine age of order

C1= 24:00:00 - Age of order (Saturday and Sunday Not Counted)

Number of Hours&Minutes between Dates and time
 

You conveniently have the same time for each of the dates in your examples
which I suspect will not always be the case so the answer is a bit more
complicated.

Have a look here
http://www.cpearson.com/excel/DateTimeWS.htm

Mike

"Jeremy" wrote:

A1= 2/11/2008 13:00:00 (Monday) - Date order entered
B1= 2/12/2008 13:00:00 (Tuesday) - Fixed date to determine age of order

C1 = 24:00:00 Age of order
(This is the formula I need) I need to be able to take out weekends and
holidays.
So for the weekends

A1=2/1/08 15:00:00 (Friday) - Date order entered
B1=2/4/08 15:00:00 (Monday) Fixed date to determine age of order

C1= 24:00:00 - Age of order (Saturday and Sunday Not Counted)

Number of Hours&Minutes between Dates and time
 

Awesome. One other questin on the same point. If I have the Day Start at
0:00 and the day end at 24:00:00 will that account for a 24 hour work day?

"Mike H" wrote:

You conveniently have the same time for each of the dates in your examples
which I suspect will not always be the case so the answer is a bit more
complicated.

Have a look here
http://www.cpearson.com/excel/DateTimeWS.htm

Mike

"Jeremy" wrote:

A1= 2/11/2008 13:00:00 (Monday) - Date order entered
B1= 2/12/2008 13:00:00 (Tuesday) - Fixed date to determine age of order

C1 = 24:00:00 Age of order
(This is the formula I need) I need to be able to take out weekends and
holidays.
So for the weekends

A1=2/1/08 15:00:00 (Friday) - Date order entered
B1=2/4/08 15:00:00 (Monday) Fixed date to determine age of order

C1= 24:00:00 - Age of order (Saturday and Sunday Not Counted)