See your other thread.
--
David Biddulph

JB Bates wrote:
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" wrote:

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

"Kyle" wrote in message
...
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,