I have an Excel spreadsheet that calculates the difference between two times. The formula that I'm using, for example, is as follows:
Cell A1 12:00 PM Cell B1 12:30 PM Cell C1 =minute(B1-A1) and the result is 30 which is what I'm looking for, but when I try: Cell A1 11:55 PM Cell B1 12:05 AM what formula do I use to get the result of 10?
I get an error or wrong calculation. Can someone help me with this so that I'll get the correct result of 10?
Also, if the time is, let's say, 71 minutes, how can I get a result of 1 hour and 11 minutes if possible?