Hi,
I have a spreadsheet that contains a list of alarms. Amongst the data in the spreadsheet is a list of duration of the alarm. This is listed as hours, minutes and seconds 00:00:00). I want add these together so I can see total alarm duration for a period of time. If I use the formula A1+A2+A3+A4.....etc it adds up correctly. Problem is if I have a lot of them to add it would take ages to add a formula in the format I've shown. If I use the sum function or the autosum function it returns a zero result. I know this is probably a pretty daft question but it's driving me nuts!