Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date and time in cell
Is there any way of entering the date and time without having to put the
separtors in (01/01/2007 21:15), how can I just enter the numbers 010120072115 and have EXCEL put the separtors in for me, can I get my cells to look like this somehow or am I just hoping for too much _ _ / _ _ / _ _ _ _ / _ _ : _ _ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date and time in cell
Excel has no "input mask" type of function/format that will enter dates in this
manner. Using event code it is possible. See Chip Pearson's site for details and code. http://www.cpearson.com/excel/DateTimeEntry.htm Otherwise you would need a helper cell with a formula to parse the date and time. Gord Dibben MS Excel MVP On Fri, 1 Dec 2006 20:29:00 -0800, tankerman wrote: Is there any way of entering the date and time without having to put the separtors in (01/01/2007 21:15), how can I just enter the numbers 010120072115 and have EXCEL put the separtors in for me, can I get my cells to look like this somehow or am I just hoping for too much _ _ / _ _ / _ _ _ _ / _ _ : _ _ |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date and time in cell
At CPEARSON.COM I was able to get the format I am looking for but the formats
are for individual cells and I just can not seem to figure out how to get them in the same cell because I am having to subtract the "TIME and DATE" of one cell from the "TIME and DATE" of another. I can get it to work perfectly if I put in the separators and space myself. "Gord Dibben" wrote: Excel has no "input mask" type of function/format that will enter dates in this manner. Using event code it is possible. See Chip Pearson's site for details and code. http://www.cpearson.com/excel/DateTimeEntry.htm Otherwise you would need a helper cell with a formula to parse the date and time. Gord Dibben MS Excel MVP On Fri, 1 Dec 2006 20:29:00 -0800, tankerman wrote: Is there any way of entering the date and time without having to put the separtors in (01/01/2007 21:15), how can I just enter the numbers 010120072115 and have EXCEL put the separtors in for me, can I get my cells to look like this somehow or am I just hoping for too much _ _ / _ _ / _ _ _ _ / _ _ : _ _ |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter date and time in cell
You could try
=DATE(MID(A1,LEN(A1)-7,4),MID(A1,LEN(A1)-9,2),LEFT(A1,LEN(A1)-10))+TIME(MID(A1,LEN(A1)-3,2),MID(A1,LEN(A1)-1,2),0) and format as dd/mm/yyyy hh:mm -- David Biddulph "tankerman" wrote in message ... At CPEARSON.COM I was able to get the format I am looking for but the formats are for individual cells and I just can not seem to figure out how to get them in the same cell because I am having to subtract the "TIME and DATE" of one cell from the "TIME and DATE" of another. I can get it to work perfectly if I put in the separators and space myself. "Gord Dibben" wrote: Excel has no "input mask" type of function/format that will enter dates in this manner. Using event code it is possible. See Chip Pearson's site for details and code. http://www.cpearson.com/excel/DateTimeEntry.htm Otherwise you would need a helper cell with a formula to parse the date and time. Gord Dibben MS Excel MVP On Fri, 1 Dec 2006 20:29:00 -0800, tankerman wrote: Is there any way of entering the date and time without having to put the separtors in (01/01/2007 21:15), how can I just enter the numbers 010120072115 and have EXCEL put the separtors in for me, can I get my cells to look like this somehow or am I just hoping for too much _ _ / _ _ / _ _ _ _ / _ _ : _ _ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically enter date and time but only update once. | New Users to Excel | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |