jeudi 20 juin 2019

IF statement with concatenate and round in Excel

I am trying to create an IF statement formula in excel that converts minutes to days and hours depending on the amount. Then rounds the value to 1 or 2 decimal points and adds the descriptive text (days, hours, etc) to the end

I have tried the following which converts and adds text but does not round:

=IF(L15>=1440, CONVERT(L15,"min","day") & CONCATENATE(L15," days"), 
 IF(L15>=60, CONVERT(L15,"min","hr") & CONCATENATE(L15," hours"), 
 IF(L15<=59, CONVERT(L15,"min","min") & CONCATENATE(L15," mins"))))

Aucun commentaire:

Enregistrer un commentaire