Divide the number of seconds by (24*60*60). Set the result to a custom
format: [hh]:mm:ss

"Mark Broom" wrote:

OK I get a report from my firewall every month that shows how much time each
user spent doing things on the internet. The final number in the column for a
sample user is 94079

Can anyone help me with a formula that would turn that into HH:MM:SS if you
figure it out with a calculator it comes out to 26h 7m 59s but I would like
to get Excel to do that for me.

Thanks for your help!!
Mark