Formula Help - Number to Time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Divide the number of seconds by (24*60*60). Set the result to a custom
format: [hh]:mm:ss
 
Back
Top