Converting Elapsed Time to Minutes

I want to convert elapsed time (currently showing as H:M) to minutes only. A1=StartTime, B1=EndTime, and C1=ElapsedTime. The formula in C1 is =HOUR(B1-A1)*60+MINUTE(B1-A1), and it works fine as long as I don't have a PM time in A and an AM time in B (or vice versa); otherwise I am getting an overflow error (Excel seems to have a problem with what it sees as a negative result). I have tried to remedy this by using the military time standard (24 hour basis) but I still get the error. Does anyone have a solution to this problem? Many thanks.

Originally Posted by jcoffey

I want to convert elapsed time (currently showing as H:M) to minutes only. A1=StartTime, B1=EndTime, and C1=ElapsedTime. The formula in C1 is =HOUR(B1-A1)*60+MINUTE(B1-A1), and it works fine as long as I don't have a PM time in A and an AM time in B (or vice versa); otherwise I am getting an overflow error (Excel seems to have a problem with what it sees as a negative result). I have tried to remedy this by using the military time standard (24 hour basis) but I still get the error. Does anyone have a solution to this problem? Many thanks.

Hi jcoffey,

try formatting the cells to [h]:m

oldchippy