Prev: Adding current dates to adjacent cells automatically.
Next: Display the date in an unusual format
From: Barry on 30 Mar 2010 22:42
I would like to display a date time in the format of:

20100331213045 etc..

the 2010 being the year
the 03 being the month
the 31 being the day
213045 being the time hours minutes and seconds in military format.

this would look to cell H3 for the date time entry to display

I'm sure there's a formula there somewhere... LOL

Thanks for your help!


Barry


From: ozgrid.com on 31 Mar 2010 01:38
Date and time of: 31/03/2010 9:30:45 PM

Custom format the holding cell to: yyyymmddhhmmss
http://www.ozgrid.com/Excel/CustomFormats.htm



--
Regards
Dave Hawley
www.ozgrid.com


"Barry" <retiredndakota(a)gwtc.net> wrote in message
news:ujSWGvH0KHA.3624(a)TK2MSFTNGP05.phx.gbl...
>I would like to display a date time in the format of:
>
> 20100331213045 etc..
>
> the 2010 being the year
> the 03 being the month
> the 31 being the day
> 213045 being the time hours minutes and seconds in military format.
>
> this would look to cell H3 for the date time entry to display
>
> I'm sure there's a formula there somewhere... LOL
>
> Thanks for your help!
>
>
> Barry
>

 | 
Pages: 1
Prev: Adding current dates to adjacent cells automatically.
Next: Display the date in an unusual format