How to Sum time values together correctly

[RompStar]

Ok, Imagine Column A:

let's that's in there, Row info..

starts at A:2

0:10
0:06
0:25
0:45
2:01
0:30
0:05
0:05
0:12
0:06
0:40
2:00
0:26
0:15
0:15
2:20
2:50
0:05
0:19
0:59
0:11

ends at A:22

So, 0:11 represents 11 minutes, 60 in an hour..

under 0:11 that is a formula that sums it up

=SUM(A2:A22) for this example...

the rows that contain the time, how should that be formatted ?

and row A23 that holds the formula, how should that be formatted..

and

If Available hours is 37.5 (15 minute breaks already deducted)

1. I want to add those times correctly

2. Let's say in B22, I have this =A22/37.5 <-- format as percentage ?
that should give me the productivity, no ?

But I really want to be sure that the times are correctly added, any
ideas ?

 

[Peo Sjoblom]

If you want hh:mm you can use [hh]:mm
that way it will continue after 24 hours

=(A22*24)/37.5

 

[Bob Phillips]

A2:A22 - format as hh:mm

A23 format as [hh]:mm

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[RompStar]

Great info, so for sums of time greater then 24 hours I have to use
[hh]:mm instead of [h]:mm and hh:mm instead of h:mm ? right ?

What the difference between the bracket [ ] and no bracket ?

 

[Bob Phillips]

Not quite, it is the [ ] that caters for more than 24 hours. The difference
in [h] and [hh] is that if then number of hours is less than 10, say 8, the
first shows a 8, the second as 08. I just prefer the latter.

In practice, you can use [h]:mm or [hh]:mm for all time showings.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[RompStar]

cool info, thanks