To convert time to decimal values
Nathan Bain wrote on December 31, 1969 19:00 EST |
that is one way but there is another way
=(V4-INT(V4))*24
where v4 is a cell containg a time value
if v4= 12:35 it returns a value of 12.58 |
Coverting Minutes to Hours and Minutes
John C. Roberts wrote on December 31, 1969 19:00 EST |
| I would like to take the number of minutes it takes to accomplish a process, then add the minutes total for a week for that particular process, then convert the total minutes to the number of hours and minutes it took to accomplish these processes for the week |
Good idea
vba maniac wrote on December 31, 1969 19:00 EST |
| =(V4-INT(V4))*24 is working also with seconds and fractials |
excel's way
ac wrote on December 31, 1969 19:00 EST |
| ((a1)*1440)/60 |
Converting elapsed time [H:M] to minutes in Excel
jcoffey wrote on December 31, 1969 19:00 EST |
| The formula =HOUR(H18-F18)*60+MINUTE(H18-F18) works as long as everything is within the same time phase (AM or PM) however when I enter times that span both, such as [11:59 PM and 12:17 AM] I get an overflow error. I know this is because Excel has a problem with negative time values but there must be a way to get the result I need. What am I doing wrong? |
Converting elapsed time [H:M] to minutes in Excel
Dan Piercy wrote on December 31, 1969 19:00 EST |
Although i am sure there is a better way to solve your problem the solution i use is dependent of using the 24 hour clock, in your above example i would put 23:59 and 24:17 and this will give you the correct result.
This can be extended to what ever time you need for example 4am would be 28:00. Let me know if this helps in your situation. |
Coverting Time to decimal Numbers
Ola Adeyemi wrote on December 31, 1969 19:00 EST |
The tips above offers the most easy to apply methods in respect of the above problems.
I hve been strugling with these problems within the last 24 hours.
I am very happy to find a solution via your tips.
Thanx for posting your tips online.
Ola |
Coverting time to decimal
Jimmy wrote on December 31, 1969 19:00 EST |
Hi
This is the quickest that works for me
Using the ratio
1 hour = 0.041666667
thus
time to decimal
=[your time]/0.041666667
format that cell to a number
|
Analog to Decimal
Harvey Riddle wrote on December 31, 1969 19:00 EST |
To convert analog hours and minutes (2:30) to a decimal value (2.5 hours) use the following
=(HOUR(A1)*60+MINUTE(A1))/60
where A1 is the cell containing the analog time |
The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
