Format a cell as General and enter:

0.020833333

Then re-format to any desired time format.
--
Gary''s Student - gsnu200740


"P Boric" wrote:

I have a worksheet with telephone expenditures and want to track them. but
some cells have a strange value, for instance one displays the following
value: 30:00:00 but in the formula field appears: 01-01-1900 6:00:00
Excel believes the value is 30 hours, but the right value is 30 minutes.
Other cells are OK, but when I add them, the wrong value alters the result
How can I fix the problem? I've tried changing the format or changing by
hand to the right value (30 minutes), but without success
Regards
Patricio Boric