View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Dave Gerecke Dave Gerecke is offline
external usenet poster
 
Posts: 4
Default How to add hours and minutes?

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