Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
time formats | Excel Discussion (Misc queries) | |||
Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
Time - converting HH:MM:SS to Minutes | Excel Worksheet Functions | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) |