» Converting Time to Decimal Values

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

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

=(V4-INT(V4))*24 is working also with seconds and fractials

((a1)*1440)/60

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?

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.

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

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

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