Claus Busch wrote:

Hi Terry,

Am Mon, 17 Aug 2015 15:32:03 +0100 schrieb Terry Pinnell:

I have Time entries in cells in the form hh:mm:ss, e.g 15:47:30,
03:53:08, etc.

How can I display these as hours and decimals please, e.g. 15.792,
3.886, etc ?

your time in A1

=A1*24 and format the cell General


Regards
Claus B.


Many thanks Claus - so simple once you know!


--
Terry, East Grinstead, UK