Calculate elapsed time Excel 2003

  • Thread starter Thread starter Legal Learning
  • Start date Start date
L

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
 
=(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
 
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
 
Thanks so much Peo. I was missing the *24 and should have realized that as
it is considered 24 hours in my day!
 
Back
Top