Don't forget to turn it into a fraction of one day
[vCode]
ActiveSheet.Range("B3").Value = "The entire process took " & _
Format$((timet2 - Now)/24/60/60, "h:mm:ss") & " hours."
[/Code]
Don't forget to turn it into a fraction of one day
[vCode]
ActiveSheet.Range("B3").Value = "The entire process took " & _
Format$((timet2 - Now)/24/60/60, "h:mm:ss") & " hours."
[/Code]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote