If you want to see just the 94, format as [h]. Otherwise =A2*24 and format
as Number or General, not Time.
Remember that this is hours, not minutes.

Formatting as [m] will show 5640, as will =A2*24*60 if you format as Number
or General, not Time.
--
David Biddulph

"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!!