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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You may use TIME and FORMAT in the same formula, something like:
=TEXT(TIME(INT(A1),MOD(A1,1)*100,0)+TIME(INT(A2),MOD(A2,1)*100,0),"[hh]:mm")

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

Squeeky

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

Hope this helps,
Miguel.

squeeky said:
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?
Click to expand...
Click to expand...
 
Back
Top