converting seconds in hh:mm:ss
Thanks, it works.
Do you know what formula can I use to multiply these minute to amount ??
I have 1:54:30*2.18
What's the right way to do it ?
"chillihawk" wrote:
It's a good question this one. Presume you have the number of seconds
to convert in cell N13 then put this formula in cell N14
=INT(N13/3600)&":"&INT(((N13/3600)-INT(N13/3600))*60)&":"&INT((((N13/3600)-INT(N13/3600))*60-INT(((N13/3600)-INT(N13/3600))*60))*60)
I imagine this could be done more succinctly, I'd be interested to see
other answers.
HTH
|