Forum Discussion
Solved
Small problem using time conversion
I've been using a time conversion for my mp3s and for some reason it has quit and I have no clue as to why. Here's the conversion formula: =TIME(0,INT(I1829*24),MOD(I1829*24,1)*60). The conversion i...
- Just to let you know that the conversion is working again. I just entered some data and tried the conversion and it worked. I've done this conversion for over 3000 mp3's and it worked, why it stopped working, I have no idea. Trying to explain what you're trying to do and put it in as simple terms as possible so others can understand is rather challenging especially if you're not proficient with the program as others may be. I appreciate the help but the next time I have a problem I'll use more attachments. Pictures are worth a thousand words, especially when you're trying to explain a problem. Thanks again.
OOps, made a mistake it copies the result if I1 down to I1850 not K1, not paying attention. All cells are highlighted as you mention in your last post and I use Fill>down. This has only happened ever since I went to Office 365. I still have my Office 2013 on my other computer and I have no problems with the conversion.
Just to let you know that the conversion is working again. I just entered some data and tried the conversion and it worked. I've done this conversion for over 3000 mp3's and it worked, why it stopped working, I have no idea. Trying to explain what you're trying to do and put it in as simple terms as possible so others can understand is rather challenging especially if you're not proficient with the program as others may be. I appreciate the help but the next time I have a problem I'll use more attachments. Pictures are worth a thousand words, especially when you're trying to explain a problem. Thanks again.
Hi Thomas,
Thank you for the feedback. Yes, pictures and even more better sample files without sensitive information help to answer a lot.
