Hello all,
First - thanks in advance for the help!
I think my question is fairly easy for you excel gurus out there:
I'd like a formula to autofill a large range of cells (>5000 rows) with time intervals of thirty seconds.
I'd also like the time to be continuous; in other words for 25 hours, i'd like it to say 25:00:00. Cell underneath would be 25:00:30, etc.
I would not like it to reset back to 0:00:00 after the first 24 hour interval.
suggestions please?
Thanks,
JM
Bookmarks