Remember Me?

#1
May 20th 05, 03:20 PM
 pgcam Posts: n/a
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

#2
May 20th 05, 04:46 PM
 N Harkawat Posts: n/a

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

"pgcam" wrote in message
news

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post pgcam Excel Worksheet Functions 2 May 20th 05 07:35 PM sax30 Excel Worksheet Functions 2 April 26th 05 08:08 PM Lucky Phil Excel Worksheet Functions 1 April 17th 05 08:07 AM Sue Excel Worksheet Functions 1 March 30th 05 04:35 PM rwf Excel Discussion (Misc queries) 1 January 21st 05 04:51 AM

All times are GMT +1. The time now is 04:10 AM.