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