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?
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?
C1: (B1-A1)*24*60
Format C1 (or Column C) to be numeric.
"Michaela" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks