We pay for drive time over 50 minutes in a day. I have the drive time start time and stop time for morning and evening. I need a formula that results in the drive time over 50 minutes and if it is less than 50 minutes results zero.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Need a formula to calculate the drive time from over 50 minutes in a day
0
Answers
0
Try this formula:
=IF(((B1-A1)*24*60)>50,(B1-A1)*24*60,0)A1 is the start time and B1 is the finish time.
You also have to format the cell with this formula to General or any non-date number format.