I'm using a spreadsheet to analyze song arrangements. I know the BPM of the song.
I'd like to just listen to the song, and then input the time where I'd like to make a note (say 1:50 or 90 seconds) and have a formula determine what bar this happened at (vs. what time).
What might the formula be to determine the bar from time and BPM?
EDIT: I'm almost every case, I'm listening to music in 4/4!