How to add hours and minutes?

[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.

Can anyone help?
dave

 

[Niek Otten]

Hi Dave,

Calculating with time is well explained here:

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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

 

[Stan Brown]

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 D110, the formula is
=INT(SUM(D110)*24)&TEXT(SUM(D110),":mm")

 

[David Biddulph]

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

 

[Stan Brown]

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.

 

[Dave Gerecke]

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