tragic_candy
02-09-2015, 04:15 AM
Cheers. First time posting.
I have an excel field (or series of fields) which have time-sensitive values. I am looking to reset these values at a particular time each day. Past data does not need to be documented as it is cleared.
Example: Cell G9 has a numeric value with a limited range (0,1,2,3 let's say). If this value is greater than 0, I would like the value to reset to 0 at a particular time (0600 PST). Any suggested on if/how this is possible? Any help would be greatly appreciated.
I have an excel field (or series of fields) which have time-sensitive values. I am looking to reset these values at a particular time each day. Past data does not need to be documented as it is cleared.
Example: Cell G9 has a numeric value with a limited range (0,1,2,3 let's say). If this value is greater than 0, I would like the value to reset to 0 at a particular time (0600 PST). Any suggested on if/how this is possible? Any help would be greatly appreciated.