View Single Post
  #1   Report Post  
Wlumkong
 
Posts: n/a
Default How to enter current static time in Excel in 00:00:00.0 format?

I am using ctrl+shift+; to enter a static time in a spreadsheet but that only
gives hours & minutes without seconds and decimals. I need to have seconds
and decimal. Any thoughts?