View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Legal Learning Legal Learning is offline
external usenet poster
 
Posts: 11
Default 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