# How to do subtraction of 2 time ?

#### mrchonginhk

##### Well-known Member
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 ?

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
If you format the cell as Time, you should get 02:00.

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

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

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.

Replies
8
Views
208
Replies
17
Views
481
Replies
11
Views
549
Replies
1
Views
906
Replies
14
Views
288

Threads
1,207,284
Messages
6,077,527
Members
446,287
Latest member
tjverdugo85

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back