View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Changing formating


Assume that 0:21 is in cell A2

Put the following formula in cell B2

=A2*24*60

The explanation is that time is a fraction of one day. Therefore multiply
the fraction by 24 to change it to hours then multiply by 60 to change it to
minutes.

--
Regards,

OssieMac