Hello Excel Forum,
I am looking to find the difference between a beginning time and an ending time not using decimals, but using hours and minutes. I tried searching online but it has not translated to success. I am using a 24 hour clock, so PM and AM would not be involved in what is displayed in the cells.
I tried using the formula =TEXT(D2-E2,"hh:mm") but received an error message.
Please assist. I have also attached my excel spreadsheet for better understanding.
An example of what I was looking to achieve was:
Call Start time: 01:45
Call End time: 01:50
Elapsed time: 00:05 (hoping that a formula would calculate that the call was 5 minutes)
Bookmarks