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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

squeeky - 08 Jun 2006 02:01 GMT

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?

Reply to this Message

Miguel Zapico - 08 Jun 2006 03:26 GMT

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.

> 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
[quoted text clipped - 3 lines]
>
> Any ideas?

Reply to this Message

squeeky - 08 Jun 2006 03:35 GMT

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

Squeeky

> 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")
[quoted text clipped - 9 lines]
> >
> > Any ideas?

Reply to this Message