Hi Dave,

Calculating with time is well explained he

http://www.cpearson.com/excel/datetime.htm#AddingTimes


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dave Gerecke" wrote in message m.au...
|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.
|
| Can anyone help?
| dave