Specifying end of day as a time value

  • Thread starter Thread starter NickDanger
  • Start date Start date
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.
 
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)
 
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
 
Back
Top