I don't think the OP's question can be solved the way he wants, you gave him
one option by using a second cell that converts the value to an integer and
another would be am event macro that converts the value in the cell to an
integer directly but to keep the actual value of 15:00 in the cell but
displaying it as 3 is not possible


--

Regards,

Peo Sjoblom

"Teethless mama" wrote in message
...
This formula will do the trick

=(A1*24)-(A1--"12:00")*12


"Emerogork via OfficeKB.com" wrote:

I tried a variation on this question earlier and recevied some useful
response but now that I understand my question more, maybe I acn narrow
it
down.

I would like to store the time "15:00" in the cell but display "3".
Not 3pm or 3:00pm, just "3".

The "h" option in custom format gives me "15".

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200708/1