Subtracting Time

[Kyle]

How is it possible, or what format do I need to be able to subract time
across days. Example, would be if I'm trying to see how long it took to get
a response to a problem or breakdown. Say the request came in at 11:30PM and
the action began at 12:15AM, 45 minutes later. However, if you simply
subtract the two cells, it just puts a whole line of ##############. I
cannot figure out how to do this.

Thanks,

 

[RoadKill]

If one time is Column A and the other B, ensure those are formatted as date
fields. In the colum where you want the subtraction, say Column C, make sure
that it is formatted as a number.

 

[David Biddulph]

To allow for time wrapping round through midnight, instead of =B1-A1, use
=MOD(B1-A1,1)

 

[JB Bates]

If you then want it to round to the nearst tenth of a minute what do you do?

Say 22:43 minus 22:34 = 9 mins or .15 - but would like to return .2 as a
rounded result?

 

[David Biddulph]

See your other thread.
--
David Biddulph

If you then want it to round to the nearst tenth of a minute what do
you do?

Say 22:43 minus 22:34 = 9 mins or .15 - but would like to return .2
as a rounded result?