Converting time formats into actual time(minutes)

L

LeighM

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

Ken Wright

A time is a fraction of a day. A day in excel = 1. Half a day = 0.5. To
convert to hours simply multiply by 24. To convert to minutes simply
multiply by 24 and then multiply by 60.

http://cpearson.com/excel/datetime.htm#AddingTimes

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
R

Ragdyer

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

=ROUND(A1*24*60,1)
 
Top