Calculate elapsed time Excel 2003
 

I want to calculate the time between start and end times. For example:
Start time would be 2:30 pm and end time would be 5:45 pm. Then I want to
take that value and multiply it by 13.

Any help is greatly appreciated
--
CLG

Calculate elapsed time Excel 2003
 

=(End_start)*24*13

=(B1-A1)*24*13

format as number or currency, I assume you have some sort hourly rate/wage

--


Regards,


Peo Sjoblom

"Legal Learning" wrote in message
...
I want to calculate the time between start and end times. For example:
Start time would be 2:30 pm and end time would be 5:45 pm. Then I want to
take that value and multiply it by 13.

Any help is greatly appreciated
--
CLG

Calculate elapsed time Excel 2003
 

Subtract the smaller time from the larger time and then multiply by 13.

=(a2-a1)*13

You may want to apply a custom format:
[hh]:mm:ss



Legal Learning wrote:

I want to calculate the time between start and end times. For example:
Start time would be 2:30 pm and end time would be 5:45 pm. Then I want to
take that value and multiply it by 13.

Any help is greatly appreciated
--
CLG

--

Dave Peterson

Calculate elapsed time Excel 2003
 

Thanks so much Peo. I was missing the *24 and should have realized that as
it is considered 24 hours in my day!
--
CLG


"Peo Sjoblom" wrote:

=(End_start)*24*13

=(B1-A1)*24*13

format as number or currency, I assume you have some sort hourly rate/wage

--


Regards,


Peo Sjoblom

"Legal Learning" wrote in message
...
I want to calculate the time between start and end times. For example:
Start time would be 2:30 pm and end time would be 5:45 pm. Then I want to
take that value and multiply it by 13.

Any help is greatly appreciated
--
CLG