Time Formula .... HELP!!!

[iibobii]

I'm struggling here and could REALLY use some help. I'm trying to come up with a formula to convert a number, say 2000 (minutes) to a Time format. The data I receive is not in a time format. The problem is that when I come up with a formula, I can convert without any problems, but only up to 24 hours. After that, it kicks back down and starts back at 0:00 instead of moving up to 25 hours. For example, 2000 minutes is actually 33:24, but will only show up as 9:24 since it won't count higher than 24. Anyone have any suggestions out there???

 

[IML]

On 2002-02-27 06:31, iibobii wrote:
I'm struggling here and could REALLY use some help. I'm trying to come up with a formula to convert a number, say 2000 (minutes) to a Time format. The data I receive is not in a time format. The problem is that when I come up with a formula, I can convert without any problems, but only up to 24 hours. After that, it kicks back down and starts back at 0:00 instead of moving up to 25 hours. For example, 2000 minutes is actually 33:24, but will only show up as 9:24 since it won't count higher than 24. Anyone have any suggestions out there???

=A1/1440

with a format of [h]:mm should do the trick

result is 33:20 though.


good luck

 

[iibobii]

IML, It works!! Thank you so much! I truly do appreciate it.