Hi Everyone...
I work for a finance company who offers vehicle financing. We are trying
to track how long our approval/turn down process takes from the time that we
get the application until we've made our decision. There are a few things
that I need to accomplish, and any help would be GREATLY appreciated!

1) I currently have 4 columns set up. Column A= application date. Column B=
application time. These represent the date and time that we receive the
application. Then I have Column C= decision date and Column D=decision time.
These obviously represent the date and time that the application is either
approved or turned down. There are times when we receive an application on
(example of) Monday at 8:00 pm but don't make a decision until (example of)
Tuesday at 3:00 pm. I need a formula that will show how long in hours it
took for us to make a decision, but need to be able to account for the fact
that not all applications are received and decided on in the same day. So,
the above referenced application would need to show that it took 19 hours to
make a decision, then I would have another column set up to subtract the 12
hours that we were closed to keep the data accurate.

2) If I decide to merge the date and the time into one cell, which I'm
familiar with, would the formula be the same?

3) If there is a better way to do this, I'm open to suggestions!

THANKS IN ADVANCE FOR ANY AND ALL HELP!

What are the hours of your working day? It affects the calculation if you
receive the item and then decide the next day.
--
Gary''s Student - gsnu200725


"Leslie M" wrote:

Hi Everyone...
I work for a finance company who offers vehicle financing. We are trying
to track how long our approval/turn down process takes from the time that we
get the application until we've made our decision. There are a few things
that I need to accomplish, and any help would be GREATLY appreciated!

1) I currently have 4 columns set up. Column A= application date. Column B=
application time. These represent the date and time that we receive the
application. Then I have Column C= decision date and Column D=decision time.
These obviously represent the date and time that the application is either
approved or turned down. There are times when we receive an application on
(example of) Monday at 8:00 pm but don't make a decision until (example of)
Tuesday at 3:00 pm. I need a formula that will show how long in hours it
took for us to make a decision, but need to be able to account for the fact
that not all applications are received and decided on in the same day. So,
the above referenced application would need to show that it took 19 hours to
make a decision, then I would have another column set up to subtract the 12
hours that we were closed to keep the data accurate.

2) If I decide to merge the date and the time into one cell, which I'm
familiar with, would the formula be the same?

3) If there is a better way to do this, I'm open to suggestions!

THANKS IN ADVANCE FOR ANY AND ALL HELP!

That's another level of confusion...

M,Thurs 9-9
Tues,Wed,Fri 9-6
Sat 9-6
Sun Closed

I am ok with having it do the calculation and then having an additional
column to put in the number of hours closed to subtract off of my decision
time. Example, the formula says that it took only 1 hour to decide. I
wouldn't have to subtract anything from that. But if it took 14 hours
becuase we were closed for 12, then I would subtract 12 from my 14 to get a
real number of 2. Does that make sense?

"Gary''s Student" wrote:

What are the hours of your working day? It affects the calculation if you
receive the item and then decide the next day.
--
Gary''s Student - gsnu200725


"Leslie M" wrote:

Hi Everyone...
I work for a finance company who offers vehicle financing. We are trying
to track how long our approval/turn down process takes from the time that we
get the application until we've made our decision. There are a few things
that I need to accomplish, and any help would be GREATLY appreciated!

1) I currently have 4 columns set up. Column A= application date. Column B=
application time. These represent the date and time that we receive the
application. Then I have Column C= decision date and Column D=decision time.
These obviously represent the date and time that the application is either
approved or turned down. There are times when we receive an application on
(example of) Monday at 8:00 pm but don't make a decision until (example of)
Tuesday at 3:00 pm. I need a formula that will show how long in hours it
took for us to make a decision, but need to be able to account for the fact
that not all applications are received and decided on in the same day. So,
the above referenced application would need to show that it took 19 hours to
make a decision, then I would have another column set up to subtract the 12
hours that we were closed to keep the data accurate.

2) If I decide to merge the date and the time into one cell, which I'm
familiar with, would the formula be the same?

3) If there is a better way to do this, I'm open to suggestions!

THANKS IN ADVANCE FOR ANY AND ALL HELP!

See if you can adapt this to your needs:

http://groups.google.com/group/micro...rnum=10&hl=en#
--
Gary''s Student - gsnu200725


"Leslie M" wrote:

That's another level of confusion...

M,Thurs 9-9
Tues,Wed,Fri 9-6
Sat 9-6
Sun Closed

I am ok with having it do the calculation and then having an additional
column to put in the number of hours closed to subtract off of my decision
time. Example, the formula says that it took only 1 hour to decide. I
wouldn't have to subtract anything from that. But if it took 14 hours
becuase we were closed for 12, then I would subtract 12 from my 14 to get a
real number of 2. Does that make sense?

"Gary''s Student" wrote:

What are the hours of your working day? It affects the calculation if you
receive the item and then decide the next day.
--
Gary''s Student - gsnu200725


"Leslie M" wrote:

Hi Everyone...
I work for a finance company who offers vehicle financing. We are trying
to track how long our approval/turn down process takes from the time that we
get the application until we've made our decision. There are a few things
that I need to accomplish, and any help would be GREATLY appreciated!

1) I currently have 4 columns set up. Column A= application date. Column B=
application time. These represent the date and time that we receive the
application. Then I have Column C= decision date and Column D=decision time.
These obviously represent the date and time that the application is either
approved or turned down. There are times when we receive an application on
(example of) Monday at 8:00 pm but don't make a decision until (example of)
Tuesday at 3:00 pm. I need a formula that will show how long in hours it
took for us to make a decision, but need to be able to account for the fact
that not all applications are received and decided on in the same day. So,
the above referenced application would need to show that it took 19 hours to
make a decision, then I would have another column set up to subtract the 12
hours that we were closed to keep the data accurate.

2) If I decide to merge the date and the time into one cell, which I'm
familiar with, would the formula be the same?

3) If there is a better way to do this, I'm open to suggestions!

THANKS IN ADVANCE FOR ANY AND ALL HELP!