# difference between two time values

#### learning_grexcel

##### Active Member
Hi,

I have a column with values A1 = 1030; a2=1031; a3=1034; a4=1152; a5=1153; etc.

These values represent time "1030" means 10.30 am; 1152 means 11.52 am, respectively.

I want to find the difference between a1 and a2; a2 and a3; a3 and a4; etc in Column B

However, when I put e.g. a4-a5, it shows result ########. The answer should be 0001

How can I correct it?

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

#### Tetra201

##### MrExcel MVP
The answer is -1, not 1. Do you want do display negative minutes?

#### learning_grexcel

##### Active Member
No, even if negative, it should be positive. Thanks

#### Tetra201

##### MrExcel MVP
Two more questions:
1) If you format cell A1 as "General", what does it display?
2) What is the result of the following formula =ISNUMBER(A1)?

Replies
1
Views
100
Replies
10
Views
175
Replies
4
Views
136
Replies
6
Views
298
Replies
8
Views
196

1,190,610
Messages
5,981,916
Members
439,743
Latest member
KatieO

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

### Which adblocker are you using?

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

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