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
Hope this helps.
"Radhakant Panigrahi" wrote:
> 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.