Shoutbox

I'm having problems with a formula and number formating.

There's a program that i have which will get time information of an event (in seconds) then it copies it to the clipboard, so I paste it on MS excel. The problem is that I need the information in Minuteseconds and with autoformating, so If it's below certain time the text will go red.

I know this is basic, the problem is that I can't make it work for times, I can't even make Excel to show the correct times.

Image:


Help please?

I don't remember exactly where it is, as I haven't used Excel in ages, but it'll be in something like Format > Number or Format > Cell, and you'll have a whole list of potential formats. One of them should be Time.

To make it show in minutes you first need to make sure that the column with the second information is in second right click --> format cell --> custom --> under "Type:" write "[s]" without the "" but you also have to rememer to divide all you second columns by 86400 because excell does it all in days. And for your minutes column just do the same with the seconds but write "[m]:ss" instead.

I'm sorry but i dont know how to make it rd if it is beneath a certain point.

Thank you very much! It works

quote:

---

Originally posted by YottabyteWIzard
Thank you very much! It works

---

No problems always nice to help. And thanks for the rep too.