Turn Around Time Calculations

[KL Hanks]

I have an Excel database with with about 2000 dates and times entered. This
used for tracking the turn around time on diagnostic specimens. In the past,
when the times were greater than 60 minutes or on different days, the time
had to be manually calculated. The formula was =MINUTE (C1:B1). I know that
there is an Excel formula that will do this calculation, can someone help me
out?

The format is like this.

Column B (recieve time) has "11/20/2007 23:50 PM"
Column C (report time) has "11/21/2007 02:30 AM"

 

[Gary Taylor]

There may be a simpler method, but the following will give you the number of
minutes between the two times.
=((INT(C4)*1440)+((C4-INT(C4))*1440)-((INT(B4)*1440)+((B4-INT(B4))*1440)))

Format the results column to be a number.

 

[Beth Melton]

See if this link for date and time arithmetic in Excel helps:
http://www.cpearson.com/excel/datearith.htm

Chip has some formulas for calculating time near the bottom of the page. If
that's not what you are looking for then check the links at the bottom for
additional date/time content.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/