Questions

Add a list of times on Excel

Tags:
+
0 Votes
Locked

Add a list of times on Excel

noahfrere
I'd like to add a list starting at 5:48 PM and going down, every minute, to 11:19 PM - without having to type in each time value. Is there an easy way to do this?
  • +
    0 Votes
    noahfrere

    Got it. Just copy the formula "=cell+time(0,1,0)" and paste into a range of highlighted cells below it!

  • +
    0 Votes
    noahfrere

    Got it. Just copy the formula "=cell+time(0,1,0)" and paste into a range of highlighted cells below it!