Converting time formats into actual time(minutes)
 

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!

Converting time formats into actual time(minutes)
 

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 :-)
------------------------------*------------------------------*----------------


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

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!