Hi,
Apoligies if there is a simple answer to this as im sure there must be but i'll be damned if i can work it out.
I have a spreadsheet i update which references the custom time format hh:mm
I set up some DSUMs to extract data which worked fine but once I automated this procedure with a macro, the DSUMS stopped picking up the newly pasted data in certain time intervals, for example 11:00 would be fine but 14:30 would return 0.
Ive tried formatting everything which doesnt work, yet when i copy/paste the time interval in the base data the DSUM works.
Any advice would be greatly appreciated.
Thanks in advance
Apoligies if there is a simple answer to this as im sure there must be but i'll be damned if i can work it out.
I have a spreadsheet i update which references the custom time format hh:mm
I set up some DSUMs to extract data which worked fine but once I automated this procedure with a macro, the DSUMS stopped picking up the newly pasted data in certain time intervals, for example 11:00 would be fine but 14:30 would return 0.
Ive tried formatting everything which doesnt work, yet when i copy/paste the time interval in the base data the DSUM works.
Any advice would be greatly appreciated.
Thanks in advance
