Time Span

M

mrbalaje

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?
 
B

Bob Phillips

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

--

HTH

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

Keyur

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

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

hope this works. gott run
 
R

Ron Rosenfeld

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?
Click to expand...

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
 
C

CLR

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

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


Vaya con Dios,
Chuck, CABGx3
 
B

Barb R.

Try entering

=(a2-a1)*60*24

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