C
cs78 via OfficeKB.com
Hi everyone,
I'm having problems summing up a range of values. It's supposed to be time
but because the range of data was copied over from another program, 30
seconds would be displayed as ":30".
I've tried auto adding a "0" or "00" in front of it and changing the formats
to mm:ss but the sum of the range of figures still comes up as 00:00. Anyone
knows how I can go about summing up the total amount of time? Thanks!
I'm having problems summing up a range of values. It's supposed to be time
but because the range of data was copied over from another program, 30
seconds would be displayed as ":30".
I've tried auto adding a "0" or "00" in front of it and changing the formats
to mm:ss but the sum of the range of figures still comes up as 00:00. Anyone
knows how I can go about summing up the total amount of time? Thanks!