ExcelBanter - View Single Post

=(+B1-A1)*(60*24)
HTH,
--
Gary Brown

Please rate this posting if it is helpful to you.

"pgcam" wrote:

Had this same problem some time ago, found a solution & as is the way
with these things have lost it ! Can anyone help me with this 'simple'
calculation :

I have a 3 column spreadsheet :

(A)Start Time (B)End Time (C)Difference

Both columns (A) & (B) are expressed in hours:minutes.

I need column C to only express the difference in minutes, for Example
if the difference is 01:23, I wish to see 83 (minutes).

Tnx in advance,

Peter.....

--
pgcam