Time and Date shortcut key

[kbark]

Is there a shortcut key/combo that will input the current date and time, and if so, how do I have the cell display it as mm/yy hh:mm ?

 

[Erdinç E. Karaçam]

Hi,
Try this formula;

=TEXT(NOW();"mm/yy hh:mm")

 

[Brian from Maui]

Is there a shortcut key/combo that will input the current date and time, and if so, how do I have the cell display it as mm/yy hh:mm ?

Try Ctrl+; space Ctrl+Shift+; format the cell to your liking.

For date only cTRL+; FOR TIME ONLY CTRL+SHIFT+;

 

[Boller]

Try Ctrl+; space Ctrl+Shift+; format the cell to your liking.

But how to format the date part as mm/yy ?

 

[Brian from Maui]

[quote
Try Ctrl+; space Ctrl+Shift+; format the cell to your liking.

But how to format the date part as mm/yy ?[/quote]

The cell that houses the date/time, go to Format/Cells/Number tab/select custom and use mm/yy hh:mm

 

[Boller]

The cell that houses the date/time, go to Format/Cells/Number tab/select custom and use mm/yy hh:mm

Doesn't work for me.

Date part is fixed at dd/mm/yy.

 

[kbark]

[quote
Try Ctrl+; space Ctrl+Shift+; format the cell to your liking.

But how to format the date part as mm/yy ?

The cell that houses the date/time, go to Format/Cells/Number tab/select custom and use mm/yy hh:mm[/quote]

Thank you everyone, this worked-out great! Thanks for the fast help