How to convert serial date&time to normal date&time?

[A.M.]

I am unable to find an excel formula to change from a serial date & time (for example 40799.66667) to something like 'DD/MM/YYYY HH:MM:SS'

Any ideas out there?

Much appreciation,
AM

 

[Claus Busch]

Hi,

Am Tue, 18 Dec 2012 11:21:43 -0800 (PST) schrieb A.M.:

I am unable to find an excel formula to change from a serial date & time (for example 40799.66667) to something like 'DD/MM/YYYY HH:MM:SS'

you don't need a formula. Format the cell dd/MM/yyyy hh:mm:ss


Regards
Claus Busch

 

[joeu2004]

I am unable to find an excel formula to change from a
serial date & time (for example 40799.66667) to something
like 'DD/MM/YYYY HH:MM:SS' Any ideas out there?

If you just want to it to as such in a cell, no formula is needed. Simply
change the format of the cell. For example, right-click on the cell, click
on Format Cells, Number, then select Custom and enter "dd/mm/yyyy hh:mm:ss"
without quotes into the Type field.

However, if want that to be text or part of other text in a cell, then use
the following formula as an example:

="dated " & TEXT(A1,"dd/mm/yyyy hh:mm:ss")

where A1 contains the Excel serial number 40799.66667, which might formatted
as date and time.