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

=(+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

On Fri, 20 May 2005 11:29:18 +0000, 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.....


C1: =B1-A1

Format C1: Format/Cells/Number/Custom Type: [m]


--ron