Need a formula to calculate the drive time from over 50 minutes in a day

0

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.

Answer
Discuss

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.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login