# Subract one time from another time to get a time?

#### VAndre

##### New Member
I'd like to add/subtract some length of time from a particular time and produce a value as time.

For example:
10:00 PM - 2hours = 8:00 PM
or
10:00 PM + 3 hours = 1:00 AM

is there an easy way to do this?

Andre

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Divide the number to be subtracted by 24. e.g.

=A1 - 2/24

will return 8PM if A1 houses 10PM. Make sure the result cell is formatted as time.

P.S. If they are both times just use e.g.

=A1-B1 where A1 and B1 both hold times.

Replies
3
Views
697
Replies
1
Views
86
Replies
1
Views
284
Replies
1
Views
369
Replies
8
Views
285

1,219,819
Messages
6,150,401
Members
450,959
Latest member
Rbro

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