RE: Calculating a rate for elapsed time?
- From: "Peo Sjoblom" <PeoSjoblom@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 17 May 2005 11:46:04 -0700
=(B1-A1)*24*rate
format for number or currency
Regards,
Peo Sjoblom
"Keith" wrote:
> please be more specific as to how to do this. Thanks, Keith
>
> "Peo Sjoblom" wrote:
>
> > =total_time*24*rate formatted as number or currency
> >
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> > "Keith" wrote:
> >
> > > If in column A I have the time a job started and in column B the time a job
> > > ended and I find the time elapsed in column C. From column D I have entered
> > > a fixed rate. I want excel to calculate the amount due in column E. How do
> > > I do this?
.
- Follow-Ups:
- RE: Calculating a rate for elapsed time?
- From: Keith
- RE: Calculating a rate for elapsed time?
- From: Keith
- RE: Calculating a rate for elapsed time?
- References:
- Calculating a rate for elapsed time?
- From: Keith
- RE: Calculating a rate for elapsed time?
- From: Peo Sjoblom
- RE: Calculating a rate for elapsed time?
- From: Keith
- Calculating a rate for elapsed time?
- Prev by Date: Re: assign value for period of time
- Next by Date: Re: Function help???
- Previous by thread: RE: Calculating a rate for elapsed time?
- Next by thread: RE: Calculating a rate for elapsed time?
- Index(es):
Relevant Pages
|