View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
D D is offline
external usenet poster
 
Posts: 121
Default Convert Date Format to Minutes

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