Elapsed Time

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
 
F

Frank Kabel

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)
 
C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Calculating Elapsed Time 2
Elapsed Time Formula 6
Access Access - Elapsed Time between Records 5
Calculate how much time falls between set start and stop times 15
Custom format (time) and wrapping text in a cell 6
Formula for elapsed time 3
calculate elapsed time between dates and times 2

Top