You need to describe your problem in more detail. It may help to know that
Excel may display time as hh:mm:ss, but stores it as a decimal starting with
0.000 as 12 midnight, and 0.5 as noon. So Excel, in date/time formats, Excel
considers the number 1.5 to be Jan 1, 1900 12:00 PM. 2.25 would be Jan 2,
1900 6:00 AM. and so on.

Hope that points you in the right direction.

"Gibbyky2" wrote:

I am working on a template for stats, when i enter time in mm:ss it shows and
calculates incorrectly. can anyone help in solving this problem

thanks