View Single Post
  #1   Report Post  
mreyes
 
Posts: n/a
Default subtact between times

I want to find the difference or elasped time between to times. my
spreadsheet is setup like this:
columnA columnB columnc
START END difference
TIME TIME
22.41.34 23.18.11 =(b1 - a1)

the cells are formattted as time but the value returnd in c1 is #VALUE!

Any suggestions are appreciated.