 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2007please help w/ a time formula
I have 5 times fields the start times are in columns A & B and the end times are in Columns C, D & E. They are not in order, but cols A or B are always < C, D or E. How can I get the #of minutes between the earliest start time and latest of the end times. thank you zb =MAX(C10:E10)-MIN(A10:B10) and format the cell as [mm].  SignatureHope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. > I have 5 times fields the start times are in columns A & B and the end times > are in Columns C, D & E. They are not in order, but cols A or B are always < > C, D or E. How can I get the #of minutes between the earliest start time and > latest of the end times. > thank you zb Try this: =MAX(C1:E1)-MIN(A1:B1) this will give the answer in time format - you may need to format the cell as [m]:ss if you want the answer in minutes. Alternatively, multiply the answer by 24 and by 60 and format the cell as General or Number with 2 dp. Hope this helps. Pete > I have 5 times fields the start times are in columns A & B and the end times > are in Columns C, D & E. They are not in order, but cols A or B are always < > C, D or E. How can I get the #of minutes between the earliest start time and > latest of the end times. > thank you zb |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.