I use the format of time entry in the first line below. The text formulas give me elapsed time. The if formulas give me time in a format I can add to get a total time over several days. I need to insert a time total from previous years like 52363:10 (52363 hours and 10 min) and start keeping a cumulative time in addition to my current entries.


8/30/2012 19:50 8/30/2012 20:08 8/30/2012 20:28 8/30/2012 20:35
0:20 0:45 0:20 0:45

=TEXT(I292-H292,"h:mm") =TEXT(J292-G292,"h:mm")
=IF(ISBLANK(L292),"",TIMEVALUE(L292)) =IF(ISBLANK(M292),"",TIMEVALUE(M292))

Thank you for your assistance.