Elapsed time question

S

Steve Williams

I have a start time field and a stop time field. they are both in a "hh:mm
pm" format. How do I calculate the elapsed time between these two fields -
preferably in a "hh:mm" format.

Steve Williams
 
S

Steve Williams

Thank you for the assistance. I had tried that, but my problem was in the
formatting of the cells holding the results.

Steve Williams
 
F

Frank Kabel

Hi
simply subtracting both valuea and formating the target cell as hh_mm
should do
 

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 Ending time using Start Time and Elapsed Time 5
Cumulative days roll-over 7
Calculate Elapsed time: difference between 2 Date/Timestamp perio 4
Calculating Elapsed Time 2
Excel 2003: Count total days elapsed 12
date and time difference 19
Access Access - Elapsed Time between Records 5

Top