You are viewing our Forum Archives. To view or take place in current topics click here.
Simple Excel problem involving time
Posted:

Simple Excel problem involving timePosted:

IanP98
  • Prospect
Status: Offline
Joined: Feb 02, 201212Year Member
Posts: 698
Reputation Power: 28
Status: Offline
Joined: Feb 02, 201212Year Member
Posts: 698
Reputation Power: 28
Im not sure if this is the right place to post this but its worth a go.

Basically I need a file which has every minute of the day on it, from 00:00 to 23:59

Is there any easy way to do this or will it be a lot of copy and pasting?

Thanks
#2. Posted:
Kyle93
  • Retired Staff
Status: Offline
Joined: Jun 25, 201014Year Member
Posts: 4,078
Reputation Power: 2628
Motto: https://www.thetechgame.com/Forums/t=7804 333/vote-for-tune-of-the-week-friday-nigh ts-lockdown-dj-sets.html
Motto: https://www.thetechgame.com/Forums/t=7804 333/vote-for-tune-of-the-week-friday-nigh ts-lockdown-dj-sets.html
Status: Offline
Joined: Jun 25, 201014Year Member
Posts: 4,078
Reputation Power: 2628
Motto: https://www.thetechgame.com/Forums/t=7804 333/vote-for-tune-of-the-week-friday-nigh ts-lockdown-dj-sets.html
In the direction you want the dates to go write out the following in different cells.

00:00
00:01
00:02
00:03


Then highlight all of those cells and click bottom right and drag the bottom edge down or right and it will then count up in a 24 hour clock

[ Register or Signin to view external links. ]

For one I created for you
#3. Posted:
IMMERSIVE
  • TTG Contender
Status: Offline
Joined: Aug 22, 201014Year Member
Posts: 3,110
Reputation Power: 171
Status: Offline
Joined: Aug 22, 201014Year Member
Posts: 3,110
Reputation Power: 171
If you want random times, then use the RANDBETWEEN function
Jump to:
You are viewing our Forum Archives. To view or take place in current topics click here.