time math

working with minutes and seconds in excel?

[chewy]

Hi,

Does anyone know how to enter minutes and seconds into an excel spreadsheet?

Whenever I enter 1:28 (mm:ss) it thinks this is 1:28 AM.

I am entering this to show a trend of time spent on a site.

Theoretically as I improve the marketing, the time spent per customer will increase - if I can get Excel to behave!

Thanks,

C.

[Shane]

Try entering 00:01:28

..... Shane

[chewy]

shows as 12:01:28 AM in the edit bar still.

I think it is working, as I can sum it.

Cell has to be formated as custom hh:mm:ss

It just doesn't look right with that AM designation.

Thanks.