Hi,

1. Assuming that the cell where you input the time is at a fixed location,
enter this into the cell =NOW() and format it as hh:mm:ss to update the
time, press F9.

2. Use the latest time to subtract the earliest time and format the cell as
hh:mm:ss

Hope this helps.

"Radhakant Panigrahi" wrote:

Hi,

i need to enter the current time in a cell with hh:mm:ss foramt
there is a short cut CTRL+SHIFT+:, although it shows me the hh:mm:ss, but
the second is always in 00.is there any other way that i can enter the
current time.

And i need to find the difference between two times in the same format
hh:mm:ss. So is there any formala to find the difference between two times in
hh:mm:ss format.

regards,
radhakant