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

How to add hours and minutes?
 

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

How to add hours and minutes?
 

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/

How to add hours and minutes?
 

Format the result as [h]:mm, rather than h:mm, and then you'll be able to
see values beyond 24 hours.
--
David Biddulph

"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

How to add hours and minutes?
 

Mon, 21 Jan 2008 10:02:47 -0000 from <"David Biddulph" <groups [at]
biddulph.org.uk:
Format the result as [h]:mm, rather than h:mm, and then you'll be able to
see values beyond 24 hours.

Cool! Much more compact than my solution.

--
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/

How to add hours and minutes?
 

In article , David Biddulph wrote:

Format the result as [h]:mm, rather than h:mm, and then you'll be able to
see values beyond 24 hours.

Great! That fixes that problem!
Many Thanks
dave