[h]:mm:ss
--
David Biddulph

"NC" wrote in message
...
Hi all,

I am trying to copy a cell where time is larger than 24:00:00 in an excel
macro, for example, 35:14:45. The original cell is formated as time, and
the
copy is formatted as general. Whenever I copy and paste by macro, it
becomes
35:14:45 - 24:00:00 = 11:14:45. I have already tried the format
"hh:mm:ss"
in the macro, but it will still subtract 24:00:00 from it. How can I keep
the original time shown as 35:14:45 in the copy?

Thank you very much.

NC