Hello and thanks in advance from you time helping with this problem.![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I am using Excel 2007 on a PC and wish to do the following, have excel return a value for the time my son plays as a hockey goalie based on the time the clock show when he is switched with his goalie partner. For example commonly, he plays the first period and 10 minutes of the second period, which should produce a product of 30 minutes. The problem is at his level, Atom, they play a 15 minute 1st and 15 minute second, with a 20 minute third. I have spent the past 90 minutes trying and reading posts, and trying, and reading etc. This is what I started with.
A B
Period 1
Time pulled 12:05:00 AM
Time played =IF(OR(B1=1,B1=2),12:15:00 AM-B2,12:20:00 AM-B2)
I get an error in the formula that I can't solve. It doesn't like the time format. I have tried many different versions of the formatting with no success. I am a novice user of excel and enjoy the challenge of solving these problems on my own, but I can't seem to figure this one out.
I'm being careful to enter the 'time pulled' data as 0:05:00 but i guess I'm missing something. Further I did see an example in these forums regarding using a VBE, which looks interesting, in order to not need to enter the colon every time. But I would first like to get this formula working and then work on tweaking it.
Any help is most appericated.
Thanks,
Kelly
I am using Excel 2007 on a PC and wish to do the following, have excel return a value for the time my son plays as a hockey goalie based on the time the clock show when he is switched with his goalie partner. For example commonly, he plays the first period and 10 minutes of the second period, which should produce a product of 30 minutes. The problem is at his level, Atom, they play a 15 minute 1st and 15 minute second, with a 20 minute third. I have spent the past 90 minutes trying and reading posts, and trying, and reading etc. This is what I started with.
A B
Period 1
Time pulled 12:05:00 AM
Time played =IF(OR(B1=1,B1=2),12:15:00 AM-B2,12:20:00 AM-B2)
I get an error in the formula that I can't solve. It doesn't like the time format. I have tried many different versions of the formatting with no success. I am a novice user of excel and enjoy the challenge of solving these problems on my own, but I can't seem to figure this one out.
I'm being careful to enter the 'time pulled' data as 0:05:00 but i guess I'm missing something. Further I did see an example in these forums regarding using a VBE, which looks interesting, in order to not need to enter the colon every time. But I would first like to get this formula working and then work on tweaking it.
Any help is most appericated.
Thanks,
Kelly