Adding hours and minutes

Giganews Newsgroups
Subject: Adding hours and minutes
Posted by:  Peter (p.andrews…@blewyonder.co.uk)
Date: Tue, 11 May 2004

I am trying to add a column of times, e.g.6:34 + 8:44, all is fine until the
total exceeds 24 hours when it becomes a random(?) date followed by hours
and minutes, (12/5/04 8:30).  How should I format the total cell to show
just hours:minutes.

Peter

Replies