Specifying end of day as a time value

N

NickDanger

I would like to be able to ented a date/time value into a cell, that
specifies the 24 hour value. I have tried using something like,
11/3/2003 23:59:59.99, and tried rounding up, but so far no success.

I would like to be able to use this value with the value in a previous
cell and simply derive the difference. I'm just having trouble
specifying this value.

So, what do I enter to cause Excel to see the value as specifiing the
end of that day.
 
B

Bob Phillips

Nick,

How about

11/3/2003 0:00:00

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
M

Michael Hopwood

If you have just times (no date values) you can represent 24 hours with the
number 1 e.g.:

[A1] = 11:00
[B1] = 1
[C1] = =B1-A1

The result in cell C1 would be 13:00

P
 
Top