How do I construct an Excel formula based on elapsed minutes?
Posted on 2016-09-22
Using the data below, I want to build a formula that says, if the duration is less than 31 minutes, I want the message MUST ATTEND A SECOND SESSION displayed in Cell D
A B C D
Start Time End Time Duration Action
10:10 AM 10:29 AM 19 min MUST ATTEND A SECOND SESSION
9:15 AM 10:28 AM 73 min No Action Needed
10:08 AM 10:12 AM 5 min MUST ATTEND A SECOND SESSION
How do I construct the formula?