Calculating time

  Right Guard 22:08 10 Oct 2003


I want to add times (Hrs and Mins) in a column.
Simple example - to add 11.3 and 5.3 i would want to see 17 (Hrs) not 16.6.

I'm sure it can't be too difficult but just can't seem to find the right format.

Hope you can help

Paul C

  VoG II 22:11 10 Oct 2003

Just use e.g.


and ensure that the target cell is formatted as Time.

If the result exceeds 24 hours you will see strange results. If so, format the cell as Custom and enter [h]:mm as the format.

  VoG II 22:13 10 Oct 2003

Also, your "starting" cells need to be formatted as "Time".

  Right Guard 22:26 10 Oct 2003

I'll give that a try, thanks

  VoG II 22:28 10 Oct 2003

Or, if your "starting" cells are formatted as numbers in A1 and A2 then

=INT(A1)+INT(A2)+10/6*(A1-INT(A1) +(A2-INT(A2)))

will work.

  Right Guard 22:32 10 Oct 2003

=INT(A1)+INT(A2)+10/6*(A1-INT(A1) +(A2-INT(A2)))

Wow, and me of a simple mind too. I'll have to sit and figure that one out!!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

3D illustrator Billelis on how to promote yourself on social media

iMac Pro review

Apple Music : comment obtenir 3 mois gratuits ?