I'm not sure I completely follow what is going on with this value (94:00:00
is 94 hours, not minutes); but, if you want to display it as 94, you can
Custom Format the cell using "[h]" (without the quote marks).

Rick


"D" wrote in message
...
I have a spreadsheet from an outside source and the Minutes are formatted
as
a date, so in the formula bar it looks like this: 1/3/1900 10:00:00 PM
but
in the actual cell, it looks like this: 94:00:00. How can I get the cell
to
read just 94? Thanks!!