Thread: Time format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
UH woodmaster UH woodmaster is offline
external usenet poster
 
Posts: 2
Default Time format

Can someone help me format some time cells. I need hh:mm:ss.# in two
adjancent cells. i would like to type 123456 and the result come to be
12:34:45.6.
I have tried custom formating, but the simple entry does not happen. I tried
an addon from the net but it will not except the decimal. ineed to be able to
subtract two time to creat a delta time. Manuall input is to time consuming.

Thank you