Calculating time

  Right Guard 22:08 10 Oct 2003
Locked

Hi

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.

=A1+B1

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

Nokia 8 vs Galaxy S8

Best new design books 2017: From vintage infographics to the the psychology of type

iMac 21.5-inch (2017) review

Nokia 8 : design, caractéristiques techniques, date de sortie