Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert time in decimals to minutes
I'm trying to
(a) convert time shown in decimals to time in minutes. Example, I would like 3.75 to become 4:15 (4 minutes 15 seconds). (b) I then take an average of 5 or six of the above numbers. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert time in decimals to minutes
a) =TIME(INT(A1)+(MOD(A1,1)0.6),(MOD(A1,1)+IF(MOD(A1 ,1)0.6,-0.6,0))*100,0)
b) just use AVERAGE -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "joaniemic" wrote in message ... I'm trying to (a) convert time shown in decimals to time in minutes. Example, I would like 3.75 to become 4:15 (4 minutes 15 seconds). (b) I then take an average of 5 or six of the above numbers. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert time in decimals to minutes
Maybe I am missing something in the OP's question, but isn't your first
formula returning a value of hours:minutes rather than the number 4:15 as minutes:seconds? Wouldn't this... =TIME(0,INT(A1),100*MOD(A1,1)) with a Custom Format of m:ss be more in line what the OP would want? Rick "Bob Phillips" wrote in message ... a) =TIME(INT(A1)+(MOD(A1,1)0.6),(MOD(A1,1)+IF(MOD(A1 ,1)0.6,-0.6,0))*100,0) b) just use AVERAGE -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "joaniemic" wrote in message ... I'm trying to (a) convert time shown in decimals to time in minutes. Example, I would like 3.75 to become 4:15 (4 minutes 15 seconds). (b) I then take an average of 5 or six of the above numbers. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time from minutes to decimals | New Users to Excel | |||
Convert Seconds and decimals to time | Excel Discussion (Misc queries) | |||
Convert Time to Minutes | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
How do I convert Military Time to minutes? | Excel Worksheet Functions |