Times add up to over 24 hours not showing properly

[schug5]

I have several time data points that I am calculating the difference between. In some of the rows, these times total over 24 hours. I have 4 time data points: order time, exam start, exam stop, and read time. Given these hard coded numbers, I calculate the difference between each step. At the end, I try to add the calculated differences up to get a total turnaround time. I have one that should total 37:28:00 using [h]:mm:ss format. However, it is calculating 1141:28:00 and I cannot figure out what the issue is. The three numbers it is adding is 11:01, 3:14 and 23:13. These numbers are all derived from formulas. When I hard key these numbers, it works fine, but I need it to add up the formula numbers. Can anyone help???

 

[Scorpion Steve]

Hi Shug5
Can I see an example please?
I.e. What are the formulas that you are using and which cells.

 

[Scorpion Steve]

This maybe of use...
To get from hours to minutes
=A1-B2*1440
(Both cell formatted as time HH:MM)

[Adjust cell ref to suit start and finish time)

 

[schug5]

Is there a way I can attach a document or do I need to just type it out?

 

[Scorpion Steve]

Ive used imageshack.com before.
Its not that popular for members to use on here but save a screen shot and upload.
Paste the link/url on here