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


A

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
 
Ad

Advertisements

C

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
 
Ad

Advertisements

J

joeu2004

A.M. said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top