If then showing h:mm:ss

[115shelly]

Good Evening, I am trying to generate a formula to subtract time, if the result is less than 15m show zero. if the result is greater than 15m show the h:mm:ss

Link to example sheet Column H

time sheet example 3.6.2020.xlsx

Shared with Dropbox

www.dropbox.com

Thank you for your help.
Jason

 

[rondeondo]

Hi Jason
in your formula just need to put in the time function to convert your 15 to minutes:
=IF(E2-D2<TIME(0,15,0),"0",E2-D2)

 

[Peter_SSs]

Another option is to work on the other side of the "<" sign
=IF(E2-D2<1/96,"0",E2-D2)
since 15 minutes is 1/96 of a day.

Also, since your column is reporting "Time owed" (which is a number), you may want to remove those quote marks from around the 0
=IF(E2-D2<1/96,0,E2-D2)

With the quotes as you had them, then for those rows that return "0" you are returning a Text value not a Numerical value.

 

[115shelly]

Peter,

Thanks for your help!

Best wishes, Jason

 

[Peter_SSs]

You're welcome.