Calculating Minutes and Time
 

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?

Calculating Minutes and Time
 

C1: (B1-A1)*24*60
Format C1 (or Column C) to be numeric.
"Michaela" wrote in message
...
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?

Calculating Minutes and Time
 

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