Seconds into time
 

Hi Guys, I am tying to convert seconds however every time I attempt to
use the Time(,,seconds) formula it returns #NUM error. I am trying to
convert 1864800 seconds this equates to 518 hours.

Seconds into time
 

If you want to convert into hours you can just do:

=A1/60/60

and format as general.

If you want it into time format, but showing 518:00, then do this:

=A1/60/60/24

and use a custom format of [h]:mm

Hope this helps.

Pete
" wrote in message
...
Hi Guys, I am tying to convert seconds however every time I attempt to
use the Time(,,seconds) formula it returns #NUM error. I am trying to
convert 1864800 seconds this equates to 518 hours.

Seconds into time
 

If you want to know why that doesn't work, look at Excel help for the TIME
function.
For how to get the correc t answer, see Pete_UK's reply.
--
David Biddulph

" wrote in message
...
Hi Guys, I am tying to convert seconds however every time I attempt to
use the Time(,,seconds) formula it returns #NUM error. I am trying to
convert 1864800 seconds this equates to 518 hours.