Thanks, but the problem is this still reads as a time
when i enter values greater than 24 for the first number, it converts it
into military time, and for values less, when i divide by 2 it gives me
incorrect answers because it is still reading it as a time

"Niek Otten" wrote:

Enter 0:20:02

--
Kind regards,

Niek Otten

"Jake" wrote in message
...
I am having a problem with Excel
I put times in as minutes and seconds, and attempt to use the format cell
command and have tried every option under time and custom.
The program keeps reading 20:02 (20 minutes and two seconds) as 10:02 PM,
how can I keep this from happening?