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
|