Chip Pearson has examples and very good info on working with times and dates.
http://www.cpearson.com/excel/datetime.htm#AddingTimes
Gord Dibben Excel MVP
On Sat, 27 Nov 2004 00:01:57 -0000, "Tricia"
wrote:
Hi what format do I need for the cells in excel for adding time as in 01:35
(one hour thirty five minutes) + 12:35 = 14:10.
Or where can I find a tutorial or example.
Thanks Tricia