Elapsed Time

  • Thread starter Thread starter estwani
  • Start date Start date
E

estwani

Hello,
I need help in calculating Elapsed Time, for example:
start time is 6:30 AM, End Time is 5:00 PM, The slapsed
time should look like 10.5 hours.

Thanks
 
Hi
if A1 stores your start time and B1 your end time simply use
=B1-A1
and format the target cell as time

If your time can span midnight use
=B1-A1+(B1<A1)
 
Try a formula like

=((end_time - start_time)+(start_time>end_time))*24

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top