How to calculate difference in time?

[Lewis Koh]

Hi,

Is it possible to calculate the difference in time as example below?

A1 = 4/12/2010 4:11:00 PM
A2 = 5/12/2010 4:15:00 PM
A3 = A2- A1 = 24 hrs 4 mins.

Regards,
Lewis

[shg]

The way you did it is fine. Just format the result as [h]:mm

[ChemistB]

Custom Format the cell as
[hh] "hrs "mm" min"
Does that work for you?

[sighlent1]

This looks good

A1 = 4/12/2010 4:11:00 PM
A2 = 5/12/2010 4:15:00 PM

Now, in Cell A3, either:

Option 1: Type in: A3 = A2- A1
then format the cell to "h:mm"

Option 2: In A3, type in: =TEXT(A2-A1,"h:mm")

[shg]

Option 2: In A3, type in: =TEXT(A2-A1,"h:mm")

Why would you want a formula that returns a text result for a numeric value?

[Lewis Koh]

The way you did it is fine. Just format the result as [h]:mm

Hi, thanks. I got it. :-)