RE: Calculating a rate for elapsed time?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



=(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?
.



Relevant Pages