View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Convert time in cell

Assuming your time is in cell A1 a formula like this should do...

=MINUTE(A1)+SECOND(A1)/60
--
HTH...

Jim Thomlinson


"John" wrote:

I am looking for help in how to convert the following:
16:06 (16 minuts and 6 seconds) to minutes (16.1 minutes)

Cell currently reads 16:06
How do I change so cell reads 16.1?
--
John