[Resolved]Cell Formats - hh:mm:ss converts to dd/mm/yy hh:mm:ss

[Mitch_s_s]

Hi,

I am extracting values in the format of hh:mm:ss from one spreadsheet and storing it into a string
i then add the value stored in that string to another value stored in another string(hh:mm:ss)

when i then paste the new value into another workbook, the format becomes
dd/mm/yy hh:mm:ss
and in the example below the format of the destination cell becomes "scientific", although i had already set the format to hh:mm:ss

do you know how i can sort this, is it because i am adding variables using cells?

here is an example of part of the code, as this is kinda hard to explain
the variables that end in "t" are my temp variables

'location of unavailable
    ranPers.Cells(201).Select
    strUnavailt = ActiveCell.Value
    Range("K1").Value = strUnavailt
    Range("K2").Value = strUnavail
    Range("K3").Formula = "=sum(K1:K2)"
    strUnavail = Range("K3").Value
    Range("K1:K3").Clear