Excel, how do you add times with minutes more than 60
 

How do you add numbers that are not in time format? They are not in time
format as it is for addition purposes only i.e. If I worked 7 hours 1 day and
7.85 hours the next it should read 15.15 hours and minutes in total.
If using the time format it will read the results as time i.e. 15:15 in the
afternoon, this is the wrong result.

Any ideas?

Excel, how do you add times with minutes more than 60
 

You may use TIME and FORMAT in the same formula, something like:
=TEXT(TIME(INT(A1),MOD(A1,1)*100,0)+TIME(INT(A2),M OD(A2,1)*100,0),"[hh]:mm")

Hope this helps,
Miguel.

"squeeky" wrote:

How do you add numbers that are not in time format? They are not in time
format as it is for addition purposes only i.e. If I worked 7 hours 1 day and
7.85 hours the next it should read 15.15 hours and minutes in total.
If using the time format it will read the results as time i.e. 15:15 in the
afternoon, this is the wrong result.

Any ideas?

Excel, how do you add times with minutes more than 60
 

Hi Miguel, Worked a treat! Thanks! Made me also realise that my maths was dud
:)

Squeeky

"Miguel Zapico" wrote:

You may use TIME and FORMAT in the same formula, something like:
=TEXT(TIME(INT(A1),MOD(A1,1)*100,0)+TIME(INT(A2),M OD(A2,1)*100,0),"[hh]:mm")

Hope this helps,
Miguel.

"squeeky" wrote:

How do you add numbers that are not in time format? They are not in time
format as it is for addition purposes only i.e. If I worked 7 hours 1 day and
7.85 hours the next it should read 15.15 hours and minutes in total.
If using the time format it will read the results as time i.e. 15:15 in the
afternoon, this is the wrong result.

Any ideas?