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?

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

--

HTH

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


"mrbalaje" wrote in message
...
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.


--
Keyur
------------------------------------------------------------------------
Keyur's Profile: http://www.excelforum.com/member.php...fo&userid=7786
View this thread: http://www.excelforum.com/showthread...hreadid=379688

On Thu, 16 Jun 2005 09:07:09 -0700, "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?

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?