Display Time in Minutes & Seconds format

[Sai Prabhu]

I want to display time in mm:ss format. However, when I use SHift+Ctrl+Colon, it will show the cuttent time in minutes and displays 00 for the seconds no matter when I input the time. How can I get seconds to be displayed without using any VBA code?

Note: I tried changing formats to mm:ss but showing the same thing. If I use Now() funtion, the value of the cell gets changed to current time when we change/input other cells in the spreadsheet.

 

[Faseeh]

Dear Sai,

Please post sample data/file.

 

[Khalid NGO]

Hi Sai,
Using Short key of Ctrl+Shift+: will only enter hh:mm
and force ss to zero.

However, you can use Macro then assign a short key as you wish:

ActiveCell.Value = Time
ActiveCell.NumberFormat = "hh:mm:ss AM/PM"

Regards,

 

[Sai Prabhu]

Hi Sai,
Using Short key of Ctrl+Shift+: will only enter hh:mm
and force ss to zero.

However, you can use Macro then assign a short key as you wish:

ActiveCell.Value = Time
ActiveCell.NumberFormat = "hh:mm:ss AM/PM"

Regards,

Thank You. It helps.