Time Span

In cell A1 I have entered the time as 11:00 am and in cell A2 I have entered
the time as 11:25 am.

In Cell A3, I want the time span between the cell A2 and A1.

i.e., A2-A1= 25 mins

I want even the text "mins" to be appered in the cell A3.

Any formula to do this?

This works ok i think. i checked few examples. sometimes the decimal is .99999... (Like 10:00 and 11:25) so you might have to work around that.

=(MIN((A2-A1),2))*1440 & " min(s)"

hope this works. gott run.

=(A2-A1)*24*60&" mins"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"mrbalaje" <[email protected]> wrote in message
news:[email protected]...
> In cell A1 I have entered the time as 11:00 am and in cell A2 I have
entered
> the time as 11:25 am.
>
> In Cell A3, I want the time span between the cell A2 and A1.
>
> i.e., A2-A1= 25 mins
>
> I want even the text "mins" to be appered in the cell A3.
>
> Any formula to do this?

On Thu, 16 Jun 2005 09:07:09 -0700, "mrbalaje"
<[email protected]> wrote:

>In cell A1 I have entered the time as 11:00 am and in cell A2 I have entered
>the time as 11:25 am.
>
>In Cell A3, I want the time span between the cell A2 and A1.
>
>i.e., A2-A1= 25 mins
>
>I want even the text "mins" to be appered in the cell A3.
>
>Any formula to do this?

Assuming your numbers are Excel times (and not text strings):

A3: =A2-A1

Format the cell as (Format/Cells/Number/Custom Type: )
[m] "mins"


--ron

If it was formated as date/time
in A3 enter
=(A2-A1)*24*60 & " mins"

"mrbalaje" wrote:

> In cell A1 I have entered the time as 11:00 am and in cell A2 I have entered
> the time as 11:25 am.
>
> In Cell A3, I want the time span between the cell A2 and A1.
>
> i.e., A2-A1= 25 mins
>
> I want even the text "mins" to be appered in the cell A3.
>
> Any formula to do this?

If you have both times within the same day......

=(A2-A1)*1440&" mins"


Vaya con Dios,
Chuck, CABGx3



"mrbalaje" wrote:

> In cell A1 I have entered the time as 11:00 am and in cell A2 I have entered
> the time as 11:25 am.
>
> In Cell A3, I want the time span between the cell A2 and A1.
>
> i.e., A2-A1= 25 mins
>
> I want even the text "mins" to be appered in the cell A3.
>
> Any formula to do this?

Try entering

=(a2-a1)*60*24

and formatting the cell to Custom and fill in the following in the field
0 "mins"

"mrbalaje" wrote:

> In cell A1 I have entered the time as 11:00 am and in cell A2 I have entered
> the time as 11:25 am.
>
> In Cell A3, I want the time span between the cell A2 and A1.
>
> i.e., A2-A1= 25 mins
>
> I want even the text "mins" to be appered in the cell A3.
>
> Any formula to do this?