Originally Posted by mikerickson Try Me.Label15.Caption = Format(Sheets("SheetSales").Range("J4").Value, "hh:mm:ss") I note that your description puts the elapsed time in J4, while your code referred to J5. I am also assuming that the Start and Currnent cells hold excel serial time and J4 has a simple subtraction formula, i.e. there is not a text value in J4. mikerickson : Thanks. Cell J4 did indeed have the Time value that I needed. It worked perfectly.
Me.Label15.Caption = Format(Sheets("SheetSales").Range("J4").Value, "hh:mm:ss")
Forum Rules