Time calculation

R

RogerZ

How can I calculate average time using hundredths of a second?

For example: 1:43:23,88 is 1 hour, 43 minutes, 23 seconds and 88 hundredths
of a second.

If I want to divide this with, say 20, it's not so difficult to do by
excluding the hundredths. But how is it done including it?

(I want to use it to calculate average lap time running tracks).

// Roger

(Sorry for my poor english...)
 
E

Earl Kiosterud

Roger,

If you haven't done so, format it to include hundredths. Format - Cells -
Number - Custom:

hh:mm:ss,00
hh:mm:ss,000
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top