Elapsed time question

[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

 

[Peo Sjoblom]

=Stop_Time-Start_Time

 

[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

 

[Frank Kabel]

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

 

[Guest]

I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consultin