Calculating time

  [DELETED] 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

  [DELETED] 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.

  [DELETED] 22:13 10 Oct 2003

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

  [DELETED] 22:26 10 Oct 2003

I'll give that a try, thanks

  [DELETED] 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.

  [DELETED] 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

How to watch the World Cup for free on TV and online

PostPanic's latest short film is a thrilling love letter to film and TV history

Best external graphics cards (eGPUs) for Mac

Les meilleurs navigateurs internet (2018)