View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Converting time formats into actual time(minutes)

With your times entered in Column A,
Format Column B as General, and try this:

=ROUND(A1*24*60,1)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"LeighM" wrote in message
...
Hi there, I was wondering if anyone has any suggestions on how to convert

a
time format (e.g. hh:mm:ss - 00:16:50) into time in actual minutes (which

in
this example would be a total of 16.8 minutes). I have an incredible

amount
of data to convert, so any suggestions would be greatly appreciated!
Many thanks!