Time Calculation in Minutes only ?

P

pgcam

Had this same problem some time ago, found a solution & as is the wa
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 Exampl
if the difference is 01:23, I wish to see 83 (minutes).

Tnx in advance,

Peter....
 
R

Ron Rosenfeld

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.....
Click to expand...


C1: =B1-A1

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


--ron
 
Top