How to do subtraction of 2 time ?

[mrchonginhk]

I have 2 time value, say:-
11:00 and 9:00 in 2 cells.

If I do 11:00 less 9:00 then it returns a strange value.

How to convert it into 2 hours or 120 mins something ?

 

[Tazguy37]

If you format the cell as Time, you should get 02:00.

 

[mrchonginhk]

If I use it in calculation, I hour difference returns a value of 0.04.

What does that mean ? Doesn't make sense to me.

1/0.04 = 25 hours.... ??

 

[tactps]

Time is used in Excel as a value between 0 and 0.99999.

The easy way to deal with time is to format the cell as [h]:mm:ss.

In your example, with my format, it will be shown as 1:00:00

 

[tactps]

To convert these value to hours, mulitply by 24.
For minutes, multiply by 1440 (24*60).
For seconds, multiply by 86400 (24*60*60).

You can use this if you don't want to format as in my last post.