Thread: Time Span
View Single Post
  #1   Report Post  
Barb R.
 
Posts: n/a
Default

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?