conversion seconds into minutes/hours
seeing your solutions makes me small......
thanks a lot!
"SteveW" wrote:
Seconds in A2, the following formula will convert
=A2/60/60/24
Format as [h]:mm:ss
Steve
On Wed, 22 Nov 2006 14:21:24 -0000, Willem
wrote:
I have a telephone-report that gives me the number of seconds each
conversation has taken. I want to convert these seconds in a hh:mm:ss
format.
Is there a function or a formula available in Excel that can do that?
Tnx
|