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.
|