How can I get elapsed time between AM start/PM stop

G

Guest

I have a simple spreadsheet with start and stop times.
I want to calculate elapsed time but can't determine how to calculate time
between 11:20 a.m. and 2:00 p.m. for instance.
 
N

Nick Hodge

You will need to enter the data as 11:20 AM or 2:00 PM for it to work or as
military time, 11:20 or 14:00. Then just simply subtract one from the other
and format as time

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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
Calculate how much time falls between set start and stop times 15
calculate elapsed time between dates and times 2
Calculate Elapsed time: difference between 2 Date/Timestamp perio 4
Access Access - Elapsed Time between Records 5
time 2
Elapsed time question 4
Elapsed time calc 7

Top