formattingproblem

[Jonsson]

Hi,

I want to format a cell as: ##":"## (custom)to get 1200 to 12:00
That works great for me until I try to paste this formula into the cell
=SUM.IF('v2'!$O$3:$O$152;$C6;'v2'!$S$3:$S$152)

I get no errors, just.......empty........

Can anyone explain what I do wrong? And what to do to get it right.

Thanks,

Thomas

 

[Frank Kabel]

Hi
don't format the cell this way: format this cell as TIME. If you don't
like the extra work of typing in the '.' have a look at
http://www.cpearson.com/excel/DateTimeEntry.htm
for a event macro that will do the conversion for you.

 

[Anony]

what is the period between m and i for?

 

[Jonsson]

Thank you for your help!

//Thomas

what is the period between m and i for?