Calculate elapsed time Excel 2003

[Legal Learning]

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

 

[Peo Sjoblom]

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

 

[Dave Peterson]

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]

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