Forum Discussion

Phishdawg's avatar
Phishdawg
Brass Contributor
Mar 25, 2023

Elimate Blank from Calculation

I've got an Excel sheet of over 19,000 items. I am going to (hopefully) use Power Automate to migrate this data from the Excel sheet to a SP List.

One issue I have is the formula in the 'WaitTime' column (=F3 - D3). This returns the Wait Time in minutes and seconds; However, where the 'Out' is blank the return is some long content I can't even make the column wide enough to read.

1. How do I resolve this is so that if 'Out' is blank nothing is returned to the 'WaitTime' column (in this case H3)?

 

 

 

Formulas and Functions

2 Replies

    • Phishdawg's avatar
      Phishdawg
      Brass Contributor
      Mar 25, 2023
      Yep, thanks!

      Now, the results appear as 12:18:34

      The 'Out' (F columns) and 'In' (D columns) are used in the calculation for 'Wait Time'.

      All three columns are set as 'Time' format.

      The desire is that the 'Wait Time' content appear as '00:18:34', meaning the wait time for that item was a fraction more than18 seconds. How do I lose the '12'?

Resources