View Single Post
  #1   Report Post  
J45on
 
Posts: n/a
Default Summation format

1. How do i make excel recognise the format i am using?
The Cell:
A1=1.12.6
to be recognised as 1minute and 12.6 seconds, divided by 1200, thus A2=0.0605

2. How do i sum the two cell below?
A2=1.6L A3=3 (without L)
that is in total A4=4.6L.