Calculating Minutes and Time

[Guest]

Ok I am looking to calculate minutes

In Cell A1 is 03/15/05 09:30 am
In Cell B1 is 03/16/05 08:25 am

In Cell C1 I want the Total Minutes

What can I use to get this result?

 

[Barb Reinhardt]

C1: (B1-A1)*24*60
Format C1 (or Column C) to be numeric.

 

[Franz]

ONTENT cell A2 CONTENT cell B2 B2 - A2 B2 - A2
03/15/05 09:30 AM 03/16/05 08:25 AM 22:55 1375
FORMAT FORMAT FORMAT FORMAT
mm/dd/yy hh:mm AM/PM mm/dd/yy hh:mm AM/PM hh:mm General
FORMULA FORMULA
=B2-A2 =(B2-A2)*60*24