Re: How Do I Eliminate the Serial Number for time from Date?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Dates are stored as whole numbers (days elapsed since the reference
date), whereas times are stored as fractions of a 24 hour day. So, you
can get the date part by

=INT(A1)

if A1 holds your date/time combination. Format as required, then the
formula can be copied down.

Hope this helps.

Pete

.

Relevant Pages

  • Re: Combining date and time in order to get the difference
    ... Excel stores dates internally as the number of elapsed days from some ... reference date. ... Times are stored as fractions of a 24-hour day. ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: How to do a conditional format for multi cells
    ... highlight the four cells and apply your conditional format to them ... You will need to use $A$5 as the reference. ... Pete ... Prev by Date: ...
    (microsoft.public.excel)
  • RE: Web Methods Lock
    ... > first user or will both be able to run the web method? ... > web service handle this? ... Is there any good reference available. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Benefits of SD or CF memory?
    ... > Pete D wrote: ... >>>CF is available in higher capacities, at lower cost per byte. ... >> By fractions of a cent sometimes, mostly they are the same price, larger ...
    (rec.photo.digital.slr-systems)
  • Re: Fiesler Storch/Cricket
    ... For the life of me I cannot find that reference. ... TIA, Pete ...
    (rec.models.scale)