Number to Days Hours:Minutes

[David M]

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!

 

[Gary''s Student]

With 515 in A1, in another cell:

=A1/(24*60)
and format as h:mm

 

[David M]

I know of that formula -- though it does not process the "515" like I want.
It turns it into the 0.35764 -- I am wanting the 515 to be turned into the
actual Day Hour and Minute. Which the representation of 515 turned into Days
Hours and Minutes is ---- 0 08:35

Thanks for your response though and I'd appreciate any further input!

 

[David M]

Okay, it was my fault on your post Gary's Student. I didn't implement the
h:mm -- though still I have one problem. When trying to implement a Day onto
that Hour and Minutes.

Any Suggestions for that?

 

[Gary''s Student]

O.K.

If A1 contains 1515 and B1 still contains =A1/(24*60) we see:
1.052083333

Format > Cells.... Number > Custom > d hh:mm
and we see:
1 01:15

Even though there may not be a "standard" format that combines date and
time, we can make a custom format that will do the job just fine.