Subtracting Time
 

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,

Subtracting Time
 

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.

"Kyle" wrote:

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,

Subtracting Time
 

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,

Subtracting Time
 

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,

Subtracting Time
 

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,