With 515 in A1, in another cell:

=A1/(24*60)
and format as h:mm
--
Gary''s Student - gsnu200771


"David M" wrote:

Currently when I am exporting from a program into Excel it takes 0 08:35 to
515 inside excel. I am wanting to try and get a formula to be able to convert
the 515 back to 0 08:35.

I'm open to any ideas as far as fixing this issue. I have scowered the web
for answers -- though as of yet have not ran across one. If you could
possibly help it would be greatly appreciated. It would also help me from
having to enter the numbers manually myself.

The Excel is usually down to like 850...so this formula would be of great
use! Thanks!