Thread: Separate two hours from one cell to two
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
something68 something68 is offline
external usenet poster
  
Posts: 38
Default Separate two hours from one cell to two
I HAVE ANOTHER DOOZY!

In Column A, row 8 I show: A, S
In Column A, row 9 I show: 1.0, 7.0

I would like Column M, row 9 to show: 1 (just the A amount)
I would like Column O, row 9 to show: 7 (just the S amount)

Reply With QuoteReply With Quote