Hi Pooja,
One reason could be whenever you enter time using key combination ( *Ctrl +
Shift + ;* ), the system time gets entered with hours and minutes only AND
it skips the second.
If you want to enter hours, minutes and seconds, then try using :-
=NOW()
and format the cell as HH:MM:SS.
You can a
Hi Pooja,
I would suggest to use custom category in the format cells window. In the
Type: option please type "HH:MM:SS" & apply this on the selected cell. Now
whenever u will change the time it will come in HH:MM:SS format.
Regards,
Deepak Rai
On Sun, Nov 1, 2009 at 12:03 AM, Pooja Sharma wrote:
