SOLVED

# time calculations with milisec

Copper Contributor

# time calculations with milisec

I have list of times with milisec in format mm:ss.000 or mm:ss,000. I change format of number a lot time but all functions still answer me dividing by zero (#delenienulou! in my language).

4 Replies

# Re: time calculations with milisec

What is the formula in the cell with the #delenienulou! error?

# Re: time calculations with milisec

=AVERAGE(C5:C17)
best response confirmed by Trieder32 (Copper Contributor)
Solution

# Re: time calculations with milisec

@Trieder32

The values in C5:C17 are left-aligned. That makes me suspect that they are text values. Try the following:

• Select C5:C17.
• Set the number format to the custom format mm:ss.000
• If you use comma as decimal separator, use mm:ss,000
• On the Data tab of the ribbon, click Text to Columns.
• Select Delimited. then click Finish.

# Re: time calculations with milisec

Thank you so much. I tried solve this problem for few weeks and you help a lot.
1 best response

Accepted Solutions
best response confirmed by Trieder32 (Copper Contributor)
Solution

# Re: time calculations with milisec

@Trieder32

The values in C5:C17 are left-aligned. That makes me suspect that they are text values. Try the following:

• Select C5:C17.
• Set the number format to the custom format mm:ss.000
• If you use comma as decimal separator, use mm:ss,000
• On the Data tab of the ribbon, click Text to Columns.
• Select Delimited. then click Finish.