I've got a column that looks like this:
12:10:10
15:32:01
14:49:20 etc...
What I need to do is add a few of them together, but the total keeps coming out as the time, when I just want it to show as the total amount. E.G: If I add 12:10:10 and 15:32:01 together, I want it to say 27:42:11 because that's the total
It's probably really easy, but I can't seem to get going today
Help an old soldier
12:10:10
15:32:01
14:49:20 etc...
What I need to do is add a few of them together, but the total keeps coming out as the time, when I just want it to show as the total amount. E.G: If I add 12:10:10 and 15:32:01 together, I want it to say 27:42:11 because that's the total
It's probably really easy, but I can't seem to get going today
Help an old soldier