Subract one time from another time to get a time?

[VAndre]

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

 

[VoG]

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.

 

[VoG]

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

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