Summing up time
 

I need help in summing up time . Guy A worked for 11:45 in day 1 , then
worked for 10:50 in day 2. How can sum up guy A's total worked hours
for 2 days. the sum should be 22:35.
Please help


--
egamalaki
------------------------------------------------------------------------
egamalaki's Profile: http://www.excelforum.com/member.php...o&userid=23858
View this thread: http://www.excelforum.com/showthread...hreadid=375020

With Day 1's time worked in A1 and Day 2's time worked in A2

Total time worked is

=A1+A2

Format using a Custom Format as elapsed time [h]:mm

PC


"egamalaki" wrote
in message ...

I need help in summing up time . Guy A worked for 11:45 in day 1 , then
worked for 10:50 in day 2. How can sum up guy A's total worked hours
for 2 days. the sum should be 22:35.
Please help


--
egamalaki
------------------------------------------------------------------------
egamalaki's Profile:
http://www.excelforum.com/member.php...o&userid=23858
View this thread: http://www.excelforum.com/showthread...hreadid=375020

Just add them up:

=A1+A2
or
=sum(a1:a2)

And a custom format of:
[hh]:mm

will show the total hours/minutes.

egamalaki wrote:

I need help in summing up time . Guy A worked for 11:45 in day 1 , then
worked for 10:50 in day 2. How can sum up guy A's total worked hours
for 2 days. the sum should be 22:35.
Please help

--
egamalaki
------------------------------------------------------------------------
egamalaki's Profile: http://www.excelforum.com/member.php...o&userid=23858
View this thread: http://www.excelforum.com/showthread...hreadid=375020

--

Dave Peterson

Try...

=A1+B1

...and custom format cell as [hh]:mm

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=375020