Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 05, 03:20 PM
pgcam
 
Posts: n/a
Default 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   Report Post  
Old May 20th 05, 04:46 PM
N Harkawat
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Calculation in Minutes only ? pgcam Excel Worksheet Functions 2 May 20th 05 07:35 PM
Time Sheet Calculation Help Needed! sax30 Excel Worksheet Functions 2 April 26th 05 08:08 PM
What formula is used to add or subtract minutes from a time in a . Lucky Phil Excel Worksheet Functions 1 April 17th 05 08:07 AM
If Statement - in time not decimal minutes Sue Excel Worksheet Functions 1 March 30th 05 04:35 PM
elapsed time calculation rwf Excel Discussion (Misc queries) 1 January 21st 05 04:51 AM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017