How to add hours and minutes?

  • Thread starter Thread starter Dave Gerecke
  • Start date Start date
D

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
 
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
 
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.
Click to expand...

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")
 
Format the result as [h]:mm, rather than h:mm, and then you'll be able to
see values beyond 24 hours.
 
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.
Click to expand...

Cool! Much more compact than my solution.
 
Back
Top