Time Calculation in Minutes only ?
 

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).


Well, I'm almost there. Using =hour(cell ref * 60) converts the hours
to minutes ok & in a seperate cell =minute (cell ref) gives me the
minutes then in a 3rd cell add the 2 together. However I would like to
have a single cell/calculation that achieves the same job (saves on
wasted columns !!).

Maybe its just my use of parentheses, but I can't get it to work.

Peter.....


--
pgcam

=(b1-a1)*60*24
and format it as number (or general)


"pgcam" wrote in message
...

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).


Well, I'm almost there. Using =hour(cell ref * 60) converts the hours
to minutes ok & in a seperate cell =minute (cell ref) gives me the
minutes then in a 3rd cell add the 2 together. However I would like to
have a single cell/calculation that achieves the same job (saves on
wasted columns !!).

Maybe its just my use of parentheses, but I can't get it to work.

Peter.....


--
pgcam