Sun, 20 Jan 2008 22:42:00 +1100 from Dave Gerecke
:
I want to calculate the following
start time finish time meal break total worked
Formula would be something like
finish time - start time - meal break = total
That part I can do

Problem
And then add the total time worked so that I would get total hours and
minutes worked over a two week period.

The end result would be something on the order of 48:20 where the 48 is
the hours and the 20 is the minutes.

Assuming the total is in cell D11, put this in the cell where you
want the display in your format:
=INT(D11*24)&TEXT(D11,":mm")

If you don't want to use D11 as a helper cell, you can format the sum
directly. Assuming the ten daily times are in D1:D10, the formula is
=INT(SUM(D1:D10)*24)&TEXT(SUM(D1:D10),":mm")

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/