View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mrrherrera mrrherrera is offline
external usenet poster
 
Posts: 5
Default Adding time after calculation

I have a spreadsheet where it calculates the time between two hours each day.
At the end of the month, I want to be able to add up the calculated times.
I've tried =Sum(a1:a31), but it does not work. Each column is formatted for
time as HH:MM. I tried changing it to HH:MM:SS that didn't work either.
Thanks in advance for your help.