If you want times in 30min intervals to represent numbers, then may be something like this will help? If you put 00:00 in A1 and 00:30 in A2 and auto-fill down, then in B1 put this
=HOUR((A1*60)/30) format to General and auto-fill down
If you want times in 30min intervals to represent numbers, then may be something like this will help? If you put 00:00 in A1 and 00:30 in A2 and auto-fill down, then in B1 put this
=HOUR((A1*60)/30) format to General and auto-fill down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks